| September 09, 2008 04:38:47 |
#4 |
| tripathi.atul |
Member Since: September 2008 Total Comments: 4 |
RE: can we insert a record in dual?
|
Dual is a table owned by sys user and public synonym for the same is created.
So it is available to all the users of the database.
To get the details use following query :
select * from all_synonyms a
where a.synonym_name = 'DUAL';
By using create table to create dual table we can insert into dual .
But without creating dual we cannot insert into dual.As we didn't have insert object privilege on sys.dual table or public synonym dual. |
| |
