This content has been marked as final. Show 5 replies
So when i set up the HR schema using SQL plus and was prompted to give a password for HR, i did that. Now when i open up the SQL plus (as administrator) and log in using username HR and the password i set for it, I can access the Schema's default tables such as employees.
However on SQL developper, I open up a new connection called HR and put the same password that HR uses on SQL plus but whenever I attempt a select statement there are no returns. It just seems like SQL developper is not connected to the database.
I am currently using the CBT nuggers tutorial for the fundamentals exam 1z0-051 and the tutorial uses both SQL developer and SQL plus.
I appreciate all the responses but unfortunately I am stuck :(
I get this message when i go to Query builder:
Text is not a valid, single SELECT statement.
Syntax Error at line 4, column 9
select * employees;
Query Builder disabled.
Edited by: Vlakarmis on Jan 2, 2013 7:04 AM