Oracle Insert Multiple Rowsby Ed ChenApril 28, 2022August 18, 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 »Oracle Insert Multiple Rows
How to Create Empty Table by CTASby Ed ChenNovember 24, 2021January 24, 2023Empty 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 Empty Table by CTAS
How to Resolve ORA-01502 Error Messageby Ed ChenJune 12, 2021February 6, 2023ORA-01502: index or partition of such index is in unusable 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 27, 2023Migrate 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