SQL

How to Resolve ORA-01440: column to be modified must be empty to decrease precision or scale

by Ed Chen
March 13, 2021April 11, 2021

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 Generate Tablespace DDL with Uniform Rules

by Ed Chen
December 9, 2020March 28, 2021

In the beginning of data migration, we usually recreate some tablespaces to accommodate data from the source. The best way to do this is to… Read More »

Oracle DROP INDEX Syntax for All Releases

by Ed Chen
July 4, 2020January 23, 2021

Here is the list of DROP INDEX Syntax for All Releases of Oracle Database. DROP INDEX Syntax for Oracle Database 21c DROP INDEX Syntax for… Read More »

Oracle ALTER INDEX Syntax for All Releases

by Ed Chen
July 4, 2020January 23, 2021

Here is the list of ALTER INDEX Syntax for All Releases of Oracle Database. ALTER INDEX syntax for Oracle Database 21c ALTER INDEX syntax for… Read More »

Oracle CREATE INDEX Syntax for All Releases

by Ed Chen
July 4, 2020January 23, 2021

Here is the list of CREATE INDEX Syntax for All Releases of Oracle Database. CREATE INDEX Syntax for Oracle Database 21c CREATE INDEX Syntax for… Read More »

Oracle ALTER TABLE Syntax for All Releases

by Ed Chen
July 1, 2020January 23, 2021

Here is the list of ALTER TABLE Syntax for All Releases of Oracle Database. ALTER TABLE syntax for Oracle Database 21c ALTER TABLE syntax for… Read More »

Oracle CREATE TABLE Syntax for All Releases

by Ed Chen
July 1, 2020January 23, 2021

Here is the list of CREATE TABLE Syntax for All Releases of Oracle Database. CREATE TABLE Syntax for Oracle Database 21c CREATE TABLE Syntax for… Read More »

Oracle DROP TABLE Syntax for All Releases

by Ed Chen
July 1, 2020January 23, 2021

Here is the list of DROP TABLE Syntax for All Releases of Oracle Database. DROP TABLE Syntax for Oracle Database 21c DROP TABLE Syntax for… Read More »

Truncate vs Delete Entire Table

by Ed Chen
May 27, 2020May 4, 2021

Truncate vs Delete Here I compare the differences between TRUNCATE and DELETE an entire table in the following chart. Question Truncate Table Delete From DDL… Read More »

How to Resolve ORA-01722: invalid number

by Ed Chen
January 22, 2020January 29, 2021

ORA-01722 ORA-01722 means that the arithmetic operation in the statement failed to calculate because one of operands cannot be converted to a valid number implicitly.… Read More »