| doubt on dual [message #20061] |
Fri, 26 April 2002 21:34  |
himangshu
Messages: 3
Registered: April 2002
|
Junior Member |
|
|
hallo
i have a confusion wheather dual
is a table in oracle or a view.
if it is view from which
table it is derived and
under which schema.
regards,
himangshu
|
|
|
|
| Re: doubt on dual [message #20062 is a reply to message #20061] |
Fri, 26 April 2002 21:38  |
Saga
Messages: 51
Registered: April 2002
|
Member |
|
|
Dual is table whose owner is user SYS. It has just one column DUMMY VARCHAR2(1). Table dual access right is given to public.
Hope it helps.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
