Answer Posted / dave
The dual table is a dummy table with one row and one column. Functions that do not require any table data can be evaluated by SELECTing from the dual table. For example,
SELECT SYSDATE FROM DUAL
returns the system time and date. The DUAL table is needed to get around the fact that the SELECT command in Oracle requires a FROM clause. For example, "SELECT SYSDATE" would fail because no tables were specified.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what functionality does oracle provide to secure sensitive information?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
how can you connect from 10g user to 11g user??
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Explain materialized views and how they are used.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What is a correlated sub-query? : sql server DBA
what is asm?
