How to Insert Multiple Rows in One Statementby Ed ChenApril 28, 2022May 25, 2022Multiple 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
How to Resolve ORA-01400: cannot insert NULL intoby Ed ChenNovember 27, 2019October 17, 20212 CommentsORA-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 OFFby Ed ChenNovember 1, 2012May 19, 2022Implicit 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