SQL

How to Generate Tablespace DDL with Uniform Rules

by Ed Chen
December 9, 2020December 17, 2020

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, 2020November 5, 2020

Here I compare the differences between TRUNCATE and DELETE an entire table in the following chart. Question Truncate Table Delete From DDL or DML? 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 »

How to Resolve ORA-01400: cannot insert NULL into

by Ed Chen
November 27, 2019January 17, 2020

ORA-01400 ORA-01400 means that there's a column which was found as NOT NULL is not listed in the INSERT statement, you have to provide a… Read More »