What is an oracle dummy table?

oracle11g dummy-data
Dilshad Abduwali picture Dilshad Abduwali · Apr 16, 2013 · Viewed 16.4k times · Source

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.

Answer

harsh picture harsh · Apr 16, 2013

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.

Related questions

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How do I do top 1 in Oracle?

How do I do the following? select top 1 Fname from MyTbl In Oracle 11g?

Read More
ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client

I'm trying to connect to a schema on 11g (v11.2.0.1.0) from a PC with 9i (v9.2.0.1) client. It seems to connect fine to some schemas, but not this one - it comes back with a ORA-01017 Invalid Username/Password error …

Read More