As title table query displays are query, there is no record,
SQL is as follows:
Select * from table1; We are inquiring - only show no record show
Select * from the test. The table1; - can query the data

The database login user test; Table space belongs to the test; Table1 table to create user for test;

Query, also do not have the same name synonyms why my current user query create table have to add a user name reference to query the records?
The problem how to troubleshoot please god to the younger brother,

CodePudding user response:

Put your this two statements execution, cut a figure on


And then run the following statement, and screenshots,

Select the user from dual

CodePudding user response:

Do not add reference F5 jammed,

CodePudding user response:

Check the dba_objects view, see how many objects of the same name