This content has been marked as final. Show 5 replies
first test the connection.
if success then write the query and check in query result pane.
What do you mean by test the connection? In SQL developer it 'connects' to the database which has the same password as I used to log into SQL PLus.
I made a new connection called HR in SQL developer with the username System and same password.
You need to be logged in as HR.
"Select * from user_tables" returns the tables owned by the current user and system doesn't own any tables.
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
Sorry guys I finally figured it out. I had the message log opened and thus could not see that actually the queries were being returned. MY apologies and thank you for your help :)