PL/SQL - Suppose, I've created a new database DB1 n i've created a table DB1.T1.Now, DESC T1 --> desplaying t

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 128 of 225

Suppose, I've created a new database DB1 n i've created a table DB1.T1.

Now, DESC T1 --> desplaying the table structure but
select * from DB1.T1 ---->giving--> table or view does not exist..
Can any one explain possible reason behind this.

Total Answers and Comments: 3

Last Update: May 20, 2008 Asked by: shamim909

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 19, 2006 07:46:06

rampratap409

Member Since: September 2006 Contribution: 111

RE: Suppose, I've created a new database DB1 n i've cr...

use only: select * from t1;

Is this answer useful? Yes | No

November 01, 2006 01:51:38

dyaneshwaran

RE: Suppose, I've created a new database DB1 n i've cr...

bcos Owner names is missing in the select

use

Select * from DB1.dbo.T1

Is this answer useful? Yes | No

May 20, 2008 09:35:54

Srinatha Reddy

Member Since: May 2008 Contribution: 2

RE: Suppose, I've created a new database DB1 n i've created a table DB1.T1.Now, DESC T1 --> desplaying the table structure butselect * from DB1.T1 ---->giving--> table or view does not exist.. Can any one explain possible reason behind this.

Select * from DB1.dbo.T1 is not working .... i tried it

select * from T1 is working.....

Is this answer useful? Yes | No

Go To Top