Skip to Main Content

SQL Developer

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!

I instaled database xe and sql developer and I don't see tables such as hr.emplyees in Tables

MilosCJun 9 2015 — edited Jun 9 2015

I can se table and its content when I write SELECT * FROM HR.EMPLYEES, but I can't see that table and others like that when I expand icon Tables.

Anyone knows why?

This post has been answered by aJohny on Jun 9 2015
Jump to Answer

Comments

aJohny
Answer

Use

SELECT * FROM HR.EMPLOYEES

Did you unlock the  hr account ?

https://satendrakumar.wordpress.com/2008/09/26/how-to-unlock-sample-hr-database-in-oracle/

Sorry, read the post wrongly.

Cheers

AJ

Marked as Answer by MilosC · Sep 27 2020
aJohny

Which user you are using to connect?

Cheers

AJ

aJohny

If you are using HR, you should be able to see the tables if you expand the tables icon, unless there is a filter set.

If you are using SYS or something, then try to expand the 'Other Users ' --> 'HR' --> Tables.

1.JPG

Cheers

AJ

MilosC

Thanks

Cheers

MC

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 7 2015
Added on Jun 9 2015
4 comments
210 views