Oracle 9i Tutorial

What are few Oracle DDL statements or commands ?

Below are few  DDL commands to create, alter, drop, and rename tables.

CREATE TABLE

  • Create a table.
  • Create a table based on another table by using a subquery.

ALTER TABLE

  • Modify table structures.
  • Change column widths, change column data types, and add columns.

DROP TABLE

  • Remove rows and a table structure.
  • Once executed, this statement cannot be rolled back.

RENAME

  • Rename a table, view, sequence, or synonym.

TRUNCATE

  • Remove all rows from a table and release the storage space used by the table.

COMMENT

  •  Add a comment to a table or a column.
  • Query the data dictionary to view the comment.

Leave a Reply