Home » SQL & PL/SQL » SQL & PL/SQL » Dual table query
Dual table query [message #37934] Thu, 07 March 2002 08:52 Go to next message
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?
Re: Dual table query [message #37936 is a reply to message #37934] Thu, 07 March 2002 09:14 Go to previous messageGo to next message
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...
Re: Dual table query [message #37941 is a reply to message #37934] Thu, 07 March 2002 10:32 Go to previous message
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;
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:
  


Current Time: Tue Oct 19 20:25:36 CDT 2021