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
VARCHAR2
How to Resolve ORA-02263: need to specify the datatype for this column
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 Resolve ORA-02263: need to specify the datatype for this column
How to Modify VARCHAR2 to CLOB of a Column
Data Type Conversion There're several major data types built in Oracle. Character Numeric Datetime LONG RAW LOB (Large Object) In each major data types, minor… Read More »How to Modify VARCHAR2 to CLOB of a Column
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