Why can I see the data in the data pane of the HR.OFFICERS table detail tab, but I cannot see the data or column headers in the data pane of MYNAME.OFFICERS? I can see the columns fine in the columns pane, but no data in the data pane.
Did you COMMIT the data after you inserted it?
A session can NOT see uncommitted data that belongs to another session.
Yes, I had committed the work, as shown above. But thank you for taking the time to look at the problem. Also, in my example above, the SELECT line was wrong, it should have read:
INSERT INTO OFFICERS VALUES (‘Captain’, ‘Smith’, ‘Samuel’);
INSERT INTO OFFICERS VALUES (‘Lieutenant Commander’, ‘Jones’, ‘Robert’);
SELECT * FROM OFFICERS;
But this still made no difference.
After having some time to play with it, I finally figured it out. I was going through the 2 day DBA document, and creating an example user “NICK”. When I had used “MYNAME” in the example above, I had actually made the user’s name in the format of “SMITH.NICK” (but actually another name). And I was not seeing data as detailed in my original post. When I created “NICK”, everything worked properly. So I tried creating the user “SMITH_NICK”, and lo and behold, it worked fine!
Evidently SQL Developer 4.0.3 cannot show data in the data pane if the user name has periods in it. The SQL Worksheet can use the user name with the periods (as long as I put it in double quotes), just not the data pane.
Is there a rule, recommendation, etc. somewhere documenting the format for a user/schema name?
Thanks to all who looked at this, and hopefully it will help somebody else learning Oracle DB.
Periods are used to separate the components of objects names so they are not valid within names.
Syntax rules for identifiers are in the SQL Language Reference Manual http://docs.oracle.com/cd/E11882_01/server.112/e41084/sql_elements008.htm#SQLRF00223
Then please mark the thread ANSWERED.
When creating user SMITH.NICK you must have enclosed the name in double quotes, otherwise you will get...
SQL Error: ORA-01936: cannot specify owner when creating users or roles
01936. 00000 - "cannot specify owner when creating users or roles"
*Cause: Users and roles do not have owners.
*Action: Don't specify an owner.
It's worthwhile repeating some advice from the doc that Jim Smith references above:
Oracle does not recommend using quoted identifiers for database object names. These quoted identifiers are accepted by SQL*Plus, but they may not be valid when using other tools that manage database objects.
So although what tripped you up was not best practice, it should work and I logged a bug.
SQL Developer Team