SQL

How to Resolve ORA-01821: date format not recognized

by Ed Chen
June 1, 2023June 2, 2023

ORA-01821 Tried to display a datetime into a readable format by TO_CHAR function, but it failed with ORA-01821. SQL> set heading off; SQL> select TO_CHAR(sysdate,… Read More »

How to Resolve ORA-02263: need to specify the datatype for this column

by Ed Chen
May 1, 2023March 24, 2023

ORA-02263 Tried to create a table, but it failed with ORA-02263. SQL> create table fruits (fruit_name not null, price number); create table fruits (fruit_name not… Read More »

How to Add New Line for Each Row

by Ed Chen
April 25, 2023April 27, 2023

What is New Line Character in Oracle? Sometimes, we need to make several lines for each row. For example, we'd like to compose some dialogs… Read More »

How to Resolve PLS-00753: malformed or corrupted wrapped unit

by Ed Chen
August 3, 2022April 25, 2023

PLS-00753 Found a compile error PLS-00753 when we compiled trigger CAT_ROLLBACK_TRIGGER owned by GSMADMIN_INTERNAL. PLS-00753: malformed or corrupted wrapped unit Finally, we found that some… Read More »

Create Table as Select (CTAS) to Tablespace

by Ed Chen
July 28, 2022March 24, 2023

Create Table as Select Tablespace Without specifying tablespace, Create Table as Select (CTAS) will go to the default tablespace of the user. How about specifying… Read More »

How to Resolve PLS-00201: identifier must be declared

by Ed Chen
June 21, 2022May 25, 2023

PLS-00201 PLS-00201 means that the identifier you specified in the statement has never been declared, so it cannot be used by the stored procedure. In… Read More »

How to Resolve PLS-00201: identifier 'DBMS_SQL' must be declared

by Ed Chen
June 21, 2022May 27, 2023
2 Comments

PLS-00201 We have talked about some common patterns of PLS-00201. Here is another case. Found some packages of CTXSYS are invalid, most compile errors are… Read More »

Oracle Insert Multiple Rows

by Ed Chen
April 28, 2022August 18, 2022

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 Resolve ORA-00905: missing keyword

by Ed Chen
December 24, 2021April 20, 2023
4 Comments

ORA-00905 ORA-00905 is a very broadly used error message, any expected keyword missing from its statement will result in ORA-00905. These are only cases we… Read More »

How to Resolve ORA-02142: missing or invalid ALTER TABLESPACE option

by Ed Chen
December 22, 2021April 7, 2022

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 »

JavaScript is not enabled. Please enable it and reload the page.