Hey,
I'm going through the SQL Developer Tutorial: Creating Objects for a Small Database, see Oracle Documentation.
I used copy and paste to insert all statements into the sql worksheet. After creating all tables BOOKS, PATRONS, TRANSACTIONS I'm inserting data into the tables. Here I'm getting the Error Message for the "INSERT INTO transactions" statements:
SQL-Fehler: ORA-01400: cannot insert NULL into ("LIBRARY_APEX"."TRANSACTIONS"."TRANSACTION_ID")
01400. 00000 - "cannot insert NULL into (%s)"
*Cause: An attempt was made to insert NULL into previously listed objects.
*Action: These objects cannot accept NULL values.
I have no idea how to handle this problem, since I've only used copy and paste to create all objects from the tutorial.
Thank you for help!
valgaldr