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
SQL
How to Resolve ORA-00905: missing keyword
ORA-00905 Tried to add a new data file to a tablespace, but it failed with ORA-00905. SQL> ALTER TABLESPACE EXAMPLE ADD '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/example02.dbf' SIZE 10M AUTOEXTEND… Read More »How to Resolve ORA-00905: missing keyword
How to Resolve ORA-02142: missing or invalid ALTER TABLESPACE option
ORA-02142 Tried to add a new data file to a tablespace, but it failed with ORA-02142. SQL> ALTER TABLESPACE EXAMPLE DATAFILE '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/example02.dbf' SIZE 10M AUTOEXTEND… Read More »How to Resolve ORA-02142: missing or invalid ALTER TABLESPACE option
How to Resolve ORA-02000: missing DATAFILES keyword
ORA-02000 There could be many types of error patterns to throw ORA-02000. Missing DATAFILES Tried to drop a pluggable database PDB completely from the container,… Read More »How to Resolve ORA-02000: missing DATAFILES keyword
How to Resolve ORA-06512: at PL/SQL line
ORA-06512 In fact, ORA-06512 does not throw the actual error it encountered. Instead, it points out the problem line in the PL/SQL program unit in… Read More »How to Resolve ORA-06512: at PL/SQL line
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 Resolve ORA-00940: invalid ALTER command
ORA-00940 ORA-00940 means that you use an invalid object type for ALTER operation, usually it's because you misspelled the object type name. First of all,… Read More »How to Resolve ORA-00940: invalid ALTER command
How to Resolve PLS-00123: program too large
PLS-00123 When we compile a big program unit, we may get PLS-00123 if it exceeds any one of compiler limitations that Oracle allows. ... declare… Read More »How to Resolve PLS-00123: program too large
How to Resolve ORA-01440: column to be modified must be empty to decrease precision or scale
ORA-01440 ORA-01440 means that you can't decrease the number precision of the column values directly by modifying the definition of the column. Let's see a… Read More »How to Resolve ORA-01440: column to be modified must be empty to decrease precision or scale
How to Resolve ORA-22858: invalid alteration of datatype
ORA-22858 When we tried to convert VARCHAR2 to CLOB, we got ORA-22858. SQL> alter table hr.locations modify (city clob); alter table hr.locations modify (city clob)… Read More »How to Resolve ORA-22858: invalid alteration of datatype