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
Primary Key
Toad Create Table Example
How to create a table in Oracle step by step? To create a new table, we can choose to compose a hand-writing PL/SQL statement which… Read More »Toad Create Table Example
PL/SQL Developer Create Table Example
How to create a new table in Oracle? To create a new table, we can choose to compose a hand-writing PL/SQL statement which may be… Read More »PL/SQL Developer Create Table Example
SQL Developer Create Table Example
How do I create a new table in Oracle? To create a new table, we can choose to compose a hand-writing SQL statement which may… Read More »SQL Developer Create Table Example
How to Resolve ORA-01502 Error Message
ORA-01502: index or partition of such index is in unusable state ORA-01502 means that the index that the optimizer want to use is in UNUSABLE… Read More »How to Resolve ORA-01502 Error Message
How to Create a Non-unique Primary Key in Oracle
The primary key in a table is just like the spine of a human being, which integrates all data in the table. In practice, we… Read More »How to Create a Non-unique Primary Key in Oracle
How to Resolve ORA-02429: cannot drop index used for enforcement of unique/primary key
ORA-02429 ORA-02429 means that the index you want to drop is a primary key. SQL> drop index hr.JHIST_EMP_ID_ST_DATE_PK; drop index hr.JHIST_EMP_ID_ST_DATE_PK … Read More »How to Resolve ORA-02429: cannot drop index used for enforcement of unique/primary key
How to Resolve ORA-12991 Error Message
ORA-12991: column is referenced in a multi-column constraint ORA-12991 means that the column you want to drop is bound to some multi-column constraints. You must… Read More »How to Resolve ORA-12991 Error Message
How to Alter Primary Key in Oracle
Modify Primary Key Sometimes, developers may design a better primary key to support the uniqueness of a table and they want to replace the current… Read More »How to Alter Primary Key in Oracle
How to Drop Primary Key in Oracle
Drop Primary Key Primary key is sort of a constraint rather than an index, you should treat it as a constraint first so as to… Read More »How to Drop Primary Key in Oracle