What is the dual table in Oracle?

by

It’s a sort of dummy table with a single record used for selecting when you’re not actually interested in the data, but instead want the results of some system function in a select statement:

e.g. select sysdate from dual;

See http://www.adp-gmbh.ch/ora/misc/dual.html

More Related Contents:

  1. How to uninstall / completely remove Oracle 11g (client)?
  2. How can I set a custom date time format in Oracle SQL Developer?
  3. Get counts of all tables in a schema
  4. Determining location of relevant tnsnames.ora file
  5. Default row ordering for select query in oracle
  6. oracle convert unix epoch time to date
  7. Oracle trigger after insert or delete
  8. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  9. Difference between a user and a schema in Oracle?
  10. Base64 encoding and decoding in oracle
  11. Oracle JDBC ojdbc6 Jar as a Maven Dependency
  12. ORA-01882: timezone region not found
  13. how to export data from log table to email body in oracle
  14. Oracle: Import CSV file
  15. PL/SQL – Use “List” Variable in Where In Clause
  16. What is the effect of placing the commit after DML in procedure?
  17. Convert timestamp datatype into unix timestamp Oracle
  18. Auto-increment in Oracle without using a trigger
  19. How to send email using Oracle 10 g Forms
  20. How to get primary key column in Oracle?
  21. How to create a user in Oracle 11g and grant permissions
  22. Trigger to enforce M-M relationship
  23. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  24. Oracle: how to INSERT if a row doesn’t exist
  25. Valid Date Checks in Oracle
  26. Functions vs procedures in Oracle
  27. Oracle: difference between max(id)+1 and sequence.nextval
  28. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  29. How to generate a version 4 (random) UUID on Oracle?
  30. Find out the history of SQL queries

Leave a Comment