How to Insert Multiple Rows in One Statement
Multiple Rows Insert To insert rows into a table, you can do it one by one. insert into fruits values ('Apple', 2); insert into fruits… Read More »How to Insert Multiple Rows in One Statement
DML
How to Resolve ORA-01400: cannot insert NULL into
ORA-01400 ORA-01400 means that there's a column which was found as NOT NULL is not listed in the INSERT statement, you have to provide a… Read More »How to Resolve ORA-01400: cannot insert NULL into
How to Set Autocommit ON and OFF
Implicit Commit In the default behavior, if session A wants to see session B's results, he must be waiting for session B to commit his… Read More »How to Set Autocommit ON and OFF