Create Table SQL Statement
What is the syntax of CREATE TABLE in Oracle? Since the syntax of CREATE TABLE statement can be very flexible and complicated, so using text-based… Read More »Create Table SQL Statement
NUMBER Datatype
How to Resolve ORA-01722: invalid number
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-01722: invalid number
How to Resolve ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06502 ORA-06502 means that PL/SQL engine cannot convert a character-typed string into a number or a subset of arithmetic for overall evaluation. Mostly, it's because… Read More »How to Resolve ORA-06502: PL/SQL: numeric or value error: character to number conversion error