Interested to Buy Any Domain ? << Click Here >> for more details...
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
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What happens on checkpoint? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
Why would you call update statistics? : sql server DBA
What is dcl? : sql server DBA
What is transparent data encryption? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What purpose does the model database server? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What would you do with an "in-doubt" distributed transaction?
how can you initialize log miner?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What is the importance of a recovery model? : sql server DBA
