Skip to Main Content

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!

Table not Seen in SQL Developer

user8708553Sep 14 2019 — edited Sep 16 2019

Hello everyone,

Hope everyone is doing well!

I created a table, PARTS, using sqlplus.  And it's fine in the sqlplus session.

But when I went into SQL Developer and ran :

    select * from PARTS;

I got the following error message :

   ORA-00942: table or view does not exist

I also tried:

   select * from SYSTEM.PARTS;

And I got the same error message.

I've already made sure that I logged in to the same database and user name

in both sessions.

Could someone please help?

Thank you so much,

cmh

This post has been answered by Solomon Yakobson on Sep 15 2019
Jump to Answer
Comments
Post Details
Added on Sep 14 2019
16 comments
5,043 views