what is dual? [message #18859] |
Tue, 19 February 2002 03:08 |
issb
Messages: 1 Registered: February 2002
|
Junior Member |
|
|
hai,
what is dual table?
what is the purpose of the table?
i can't describe the table
how can see the dual table fields?
--iss britto
|
|
|
Re: what is dual? [message #18860 is a reply to message #18859] |
Tue, 19 February 2002 03:18 |
Jarrod McReynolds
Messages: 3 Registered: February 2002
|
Junior Member |
|
|
This table is used for things that do not need a specific table. Example
select sysdate from dual.
This will give you the system date of the server that the database is on.
That is all this table is used for.
|
|
|
Re: what is dual? [message #18864 is a reply to message #18859] |
Tue, 19 February 2002 03:44 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
The DUAL Table
------------------
The table named DUAL is a small table in the data dictionary that Oracle and userwritten
programs can reference to guarantee a known result. This table has one
column called DUMMY and one row containing the value "X".
|
|
|