User:Santoshoracle

CREATE TABLE [table name] ( [column name] [datatype], ... ); CREATE TABLE employee (id int, name varchar2(30)); ALTER TABLE [table name] ADD ( [column name] [datatype], ... ); SELECT table_name, constraint_name, constraint_type FROM user_constraints;