SQL

DROP INDEX Syntax for All Releases of Oracle Database

by Ed Chen
July 4, 2020July 3, 2020

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

ALTER INDEX Syntax for All Releases of Oracle Database

by Ed Chen
July 4, 2020July 3, 2020

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

CREATE INDEX Syntax for All Releases of Oracle Database

by Ed Chen
July 4, 2020July 3, 2020

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

ALTER TABLE Syntax for All Releases of Oracle Database

by Ed Chen
July 1, 2020July 3, 2020

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

CREATE TABLE Syntax for All Releases of Oracle Database

by Ed Chen
July 1, 2020June 28, 2020

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

DROP TABLE Syntax for All Releases of Oracle Database

by Ed Chen
July 1, 2020June 30, 2020

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

Truncate vs Delete Entire Table

by Ed Chen
May 27, 2020June 1, 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 31, 2020

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 »

Oracle TO_DATE Function Examples

by Ed Chen
September 21, 2019July 11, 2020

Oracle TO_DATE Oracle TO_DATE function can convert a date time string into a value acceptable for converting string into datetime type. From another angle, TO_DATE… Read More »