4 Replies Latest reply on Jun 9, 2015 3:59 PM by MilosC

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

MilosC Jun 9, 2015 3:56 PM

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?

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

aJohny Jun 9, 2015 3:49 PM (in response to MilosC)

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
Like Show 0 Likes(0)

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

aJohny Jun 9, 2015 3:50 PM (in response to MilosC)

Which user you are using to connect?

Cheers
AJ
Like Show 0 Likes(0)

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

aJohny Jun 9, 2015 3:54 PM (in response to MilosC)

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.

Cheers
AJ
1 person found this helpful
Like Show 0 Likes(0)

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

MilosC Jun 9, 2015 3:59 PM (in response to aJohny)

Thanks

Cheers

MC
Like Show 0 Likes(0)

Actions