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
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are the different ways you can create databases in sql server? : sql server DBA
How do you open a cluster administrator? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how can you create a user-defined lock?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Where would you look for errors from the database engine?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
what do you understand by fine-grained auditing?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is replication? : sql server DBA
