Oracle DBA FAQ - Understanding SQL DDL Statements
http://dba.fyicenter.com/faq/oracle/oracle_sql_ddl_statements.html
What Are DDL Statements?
How To Create a New Table?
How To Create a New Table by Selecting Rows from Another Table?
How To Add a New Column to an Existing Table?
How To Delete a Column in an Existing Table?
How To Drop an Existing Table?
How To Create a Table Index?
How To Rename an Index?
How To Drop an Index?
How To Create a New View?
How To Drop an Existing View?
please visit this Website.
http://dba.fyicenter.com/faq/oracle/oracle_sql_ddl_statements.html
Thank you,
Team DBAFYI - DBA Resource Center
http://dba.fyicenter.com/