View Single Post

   
  #7 (permalink)  
Old 04-08-2008, 11:09 AM
CJM
 
Posts: n/a
Default Re: Noob Oracle Question

I've create a new Data File (SNEData), and a new User (SNE), which in turn
creates the Schema. [I did this in OEM]

There is another Schema called IFSAPP within the IFSP database. How do I
structure a simple SQL statement in SNE that queries IFSAPP [via SQL
Developer]?

Eg.

Select * from IFSAPP.MyTable;

I'm getting a 'SQL command not properly ended' error...

Do I need to create a Database Link; I assume I dont since the two Schema
are within the same DB.

Any ideas?

Thanks


Reply With Quote