OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » dual table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dual table [message #252335]

Wed, 18 July 2007 11:47

spsbombay
Messages: 29
Registered: June 2007

Junior Member

hi.. i have 1 query. can v alter dual table or can v insert additional rows into dual table?

Regards
Prashant

Report message to a moderator

Re: dual table [message #252336 is a reply to message #252335]

Wed, 18 July 2007 11:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

yes, you can, but should not do so.

Report message to a moderator

Re: dual table [message #252337 is a reply to message #252335]

Wed, 18 July 2007 11:51

MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA

Senior Member

Updating or inserting to dual is BAD BAD BAD BAD BAD

Report message to a moderator

Re: dual table [message #252353 is a reply to message #252335]

Wed, 18 July 2007 12:34

yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait

Senior Member

What benefit you will get out of doing so??

Report message to a moderator

Re: dual table [message #252363 is a reply to message #252353]

Wed, 18 July 2007 12:51

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Big mess!

Regards
Michel

Report message to a moderator

Re: dual table [message #252494 is a reply to message #252363]

Thu, 19 July 2007 00:55

spsbombay
Messages: 29
Registered: June 2007

Junior Member

I dont want to manipulate the table... but i encounterd this question in an interview.. n i said that it can be manipulated but this rights is only with DBA.. M i correct?

Regards,
Prashant

Report message to a moderator

Re: dual table [message #252497 is a reply to message #252494]

Thu, 19 July 2007 01:00

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No.
You can't manipulate it.
It is Oracle proprietary.
If you modify it you are no more supported.

Regards
Michel

Report message to a moderator

Re: dual table [message #252652 is a reply to message #252497]

Thu, 19 July 2007 10:01

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If you have some time, read this Asktom page; it'll show you what DUAL is and what happens when you mess it up.

Report message to a moderator

Previous Topic:	TRUNCATE PARTITION
Next Topic:	Mass update of column for all rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 03 14:05:03 CDT 2025