Note: ORA-01403: No data found

Today in the use of an insert statement is not too much meaning, after the statement is written correctly executed, did not expect ORACLE to report a ORA-01403: No data found error, after carefully checking the statements, there is no error. Because the data table under another user is inserted, it is suspected that the permission or data connection is correct, therefore, the SQL statement was executed directly under the user to which the SQL statement belongs. I did not expect to report an error. I suddenly remembered that I had encountered this problem before. I solved it at the time and forgot the specific process. But I finally remembered it because of the relationship between foreign keys and no data on foreign keys, that is, the error caused by the failure to find the associated data of the table in another table. After the foreign key is joined, the data is inserted smoothly. This time we MARK it here, saving the trouble to forget it later.

Column from shadow