CODEWITHSUNDEEP
oracle11gdummy-data
Dilshad Abduwali
Dilshad Abduwali

Reputation: 1458

What is an oracle dummy table?

I am now learning Oracle PL*SQL and having some understanding difficulties on dummy table which is called DUAL Table. Can someone explain what that is in a simple way? Please.

Upvotes: 2

Views: 21696

Answers (1)

harsh
harsh

Reputation: 7692

Clean and simple explanation @ http://en.wikipedia.org/wiki/DUAL_table

The DUAL table is a special one-row, one-column table present by default in Oracle and other database installations. In Oracle, the table has a single VARCHAR2(1) column called DUMMY that has a value of 'X'. It is suitable for use in selecting a pseudo column such as SYSDATE or USER.

Upvotes: 4

Related Questions