GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

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

 Print  |  
Question:  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.




May 05, 2008 09:35:54 #3
 Srinatha Reddy   Member Since: May 2008    Total Comments: 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.....
     

 

Back To Question