OraFAQ Forum: SQL & PL/SQL » Dual table query

Home » SQL & PL/SQL » SQL & PL/SQL » Dual table query

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

Dual table query [message #37934]

Thu, 07 March 2002 08:52

Suresh
Messages: 189
Registered: December 1998

Senior Member

I have created new table with same name as DUAL
like

CREATE TABLE DUAL(NAME VARCHAR2(10);
and table is created.
now I want original table to read but I'm unable to read it because I have created another with same name.
How can I get that Table?

Report message to a moderator

Re: Dual table query [message #37936 is a reply to message #37934]

Thu, 07 March 2002 09:14

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

You are just asking for trouble by creating a table named DUAL. Just don't do it and you will be much better off...

Report message to a moderator

Re: Dual table query [message #37941 is a reply to message #37934]

Thu, 07 March 2002 10:32

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

todd barry is right. why do you want to create table name with same name?.

prefix sys to dual

select 1 from sys.dual;

Report message to a moderator

Previous Topic:	where can i find the help about function of oracle?
Next Topic:	Getting Values from a Record Variable into a Cursor Variable

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 10:57:56 CDT 2024