I restart the computer, or this kind of situation,
Not as well to solve the problem in the morning, afternoon, able to carry out the results of some of the statements in the morning, afternoon I'll go to perform can only see the column name, table without content,
part of the statement can perform a result, don't understand what situation, show a monkey looks great god: 50. GIF [/face]

CodePudding user response:

Be on the morning of the rollback data,
Normally, when you close the PL/SQL developer, what do you do in the above all the operation will automatically commit, if when you turn off the computer, not manually close the PL/SQL developer is not know can commit, don't know when you restart the computer without the PL/SQL developer first closed,
Mainly take a look at your data filter and match them with the data in the database can line,

CodePudding user response:

The local library or library company? Could it be changed the other colleagues

CodePudding user response:

You this is not caused by data, did you look at teacher1 list name is zhang teacher,
This table more associated query problems, you can look up, separate association a table first, and see if there is any data, if you have had, and the second table, and so on,
When new data is associated with a table and cause no output, it can determine the table data is associated with the latest problem,
Finally Left the Join can be used with a NULL value is associated with failure of line,

CodePudding user response:

Thank you teacher, found the reason, is the table suddenly disappeared, puzzling, happened twice already,