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 Create an Empty Table by CTASby Ed ChenNovember 24, 2021October 30, 2021Empty Table To duplicate a table, the fast way is to use CTAS (Create Table As Select). Sometimes, the only thing you want is an… Read More »How to Create an Empty Table by CTAS
How to Resolve ORA-01502 Error Messageby Ed ChenJune 12, 2021May 14, 2022ORA-01502: index or partition of such index is in usable state ORA-01502 means that the index that the optimizer want to use is in UNUSABLE… Read More »How to Resolve ORA-01502 Error Message
How to Migrate 9i to 12c via DB Linkby Ed ChenNovember 16, 2019March 28, 2022Migrate 9i to 12c As I said in How to Resolve ORA-03134, you cannot directly access an Oracle 9i database from an Oracle 12c or… Read More »How to Migrate 9i to 12c via DB Link