SQL> select count(1)
2 from dual;
COUNT(1)
----------
1
Because there's just one column and one row that's why you'll always get 1. Here's what inside the DUAL table.
SQL> select * from dual;
D
-
X
Regards
Amir
Search found 138 matches
- Mon Aug 03, 2009 8:59 pm
- Forum: Oracle Databases
- Topic: INSERT INTO LONG RAW
- Replies: 1
- Views: 3419
Hi there Sorry for the late reply. I don't see any reason to use LONG data type in 10g database! Oracle strongly recommend to use and convert existing data to the LOB data types (BFILE) in 10g, it exists only for backward compatibility. A BFILE column or attribute stores a file locator that points t...
- Wed Jun 17, 2009 3:46 pm
- Forum: Oracle Databases
- Topic: Automate oracle startup on linux reboot
- Replies: 9
- Views: 6979
- Tue Jun 16, 2009 12:59 am
- Forum: Oracle Databases
- Topic: FRM-92050
- Replies: 3
- Views: 3961
- Sat Jun 13, 2009 9:06 pm
- Forum: Oracle Databases
- Topic: Database Cloning
- Replies: 8
- Views: 28699
- Mon Jun 08, 2009 2:38 am
- Forum: Oracle Databases
- Topic: Database Cloning
- Replies: 8
- Views: 28699
- Sun May 31, 2009 11:09 pm
- Forum: Oracle Databases
- Topic: Find out Opened Cursors and the related Objects
- Replies: 1
- Views: 3292
Hi there Here are few ways to monitor open cursors, that'll give you some idea. To monitor open cursors, query v$sesstat where name='opened cursors current'. This will give the number of currently opened cursors, by session: --total cursors open, by session select a.value, s.username, s.sid, s.seria...
- Sun May 31, 2009 11:03 pm
- Forum: Oracle Databases
- Topic: Backup (Hot & Cold)
- Replies: 1
- Views: 11665
Hi there It could be described as, in the HOT backup you don't need to shutdown the database (mostly preferred for PROD database). The RMAN and some other third party backup solutions using RMAN scripts in the background are used for that purpose. In the cold backup you just need to shutdown the dat...
- Sun May 31, 2009 10:54 pm
- Forum: Oracle Databases
- Topic: Database Cloning
- Replies: 8
- Views: 28699
Hi Kashif
Here's a super fast way to clone oracle database.
http://www.dba-oracle.com/oracle_tips_db_copy.htm
Let's know how it goes.
Have fun.
Amir
Here's a super fast way to clone oracle database.
http://www.dba-oracle.com/oracle_tips_db_copy.htm
Let's know how it goes.
Have fun.
Amir
- Fri May 15, 2009 4:54 pm
- Forum: Oracle Databases
- Topic: Can 2 databases in similar name work in a common n
- Replies: 2
- Views: 4026
- Tue May 05, 2009 2:04 pm
- Forum: Oracle Databases
- Topic: Automate oracle startup on linux reboot
- Replies: 9
- Views: 6979
- Thu Apr 23, 2009 12:29 pm
- Forum: Operating System
- Topic: usb external hard disk double icon show
- Replies: 1
- Views: 3047
- Wed Apr 22, 2009 12:23 am
- Forum: Oracle Databases
- Topic: Automate oracle startup on linux reboot
- Replies: 9
- Views: 6979
- Thu Apr 16, 2009 12:18 pm
- Forum: Oracle Databases
- Topic: Automate oracle startup on linux reboot
- Replies: 9
- Views: 6979
Hi there Please always mention the database version in your question. Here's a solution for Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 10.1.0.3: The DB server software provides the two scripts to configure automatic DB startup/shutdown with the server machine. They are $ORACLE_HOME/bin...
- Thu Apr 16, 2009 12:49 am
- Forum: Oracle Databases
- Topic: Oracle8i on CentOS 5.2
- Replies: 1
- Views: 3638
Hello To know what OS is certified with which product we use Oracle certification matrix. The OS CentOS is based on Red Hat Enterprise Linux. I verified from metalink as it's showing result below: Red Hat Enterprise Linux AS/ES 2.1 8.1.7 (8i) It means only CentOS 2.1 is certified with 8i. BTW I succ...