With navicat GUI interface table, only the class name of the table, opened in PLSQL, became a TEST table name. The class, you can know the user name, the TEST is
Navicat GUI interface is used to derive the building also can be seen in the table statements, built the table with the user name,
If it is built build predicative sentences with PLSQL table, without a user name, build out a name is a class table directly, in navicat

 select * from class 

they said no the table, how to do?

CodePudding user response:

Built building table statements PLSQL table, the user name is the user name you logged in PLSQL, you add the name of the table in front of the user name, or username. Test

CodePudding user response:

reference 1st floor js14982 response:

built building table statements PLSQL table, the user name is the user name you logged in PLSQL, you add the name of the table in front of the user name, or the user name. The test

Not ah, if the table is test the user name, I in navicat, refresh, you will see the form, and is now can't see this table,

CodePudding user response:

Show the current user does not have the table, isn't it your current user is not a test user, but the system the system user,

CodePudding user response:

Inside the tool object browser filter, select the default for my object, rather than all the object the user

CodePudding user response:

Should be PLSQL did not commit the transaction