Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TOAD for Oracle fully qualified table names

2661060Apr 24 2014 — edited Apr 24 2014

I'm trying to refer to my table via a fully qualified name in Toad for Oracle. The database name is dbName.world, schema is schema1, and table name is table1. However, the following select statement fails with the error "ORA-00903: invalid table name".

select * from [dbName.world].schema1.table1

There's a red underline below [ and the . between dbName and world. This is my first time using Toad but I do have SQL experience from MySQL, SQL Server, and SQL Developer.

How do I reference a table via a fully qualified name?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2014
Added on Apr 24 2014
2 comments
3,032 views