How to Create an Empty Table by CTAS
Empty 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
Create Table As Select (CTAS)
How to Resolve ORA-00933: SQL command not properly ended
ORA-00933 ORA-00933 means that you use an unexpected word or phrase at the position where SQL parser knows what qualified keyword should be. Use cases… Read More »How to Resolve ORA-00933: SQL command not properly ended
How to Change Column Order and Position
One developer reported that some statements like the following failed to complete. SQL> insert into finapp.invoices_history select * from finapp.invoices_month where invoice_date < sysdate -30;… Read More »How to Change Column Order and Position
How Oracle Search View Text in ALL_VIEWS
ALL_VIEWS Dictionary view ALL_SOURCE contains only several object types like PROCEDURE, PACKAGE BODY, FUNCTION, TYPE except VIEW. If you want to search some text for… Read More »How Oracle Search View Text in ALL_VIEWS
How to Resolve ORA-00932: inconsistent datatypes: expected CHAR got LONG
ORA-00932 ORA-00932 means that SQL engine wanted to retrieve CHAR strings, but it saw LONG data type, which is unsearchable. So SQL engine refused to… Read More »How to Resolve ORA-00932: inconsistent datatypes: expected CHAR got LONG