DATA DEFINITION LANGUAGE

• This is the First Sub Language in SQL which is Used to define database Objects such as TABLE,VIEW,INDEX,PROCEDURE etc.,
• This Language contains following commands.

               1.CREATE
               2.ALTER
               3.RENAME
               4.TRUNCATE
               5.DROP

1.CREATE:This command is used to create any database objects such as TABLE,VIEW etc.,
   Syntax to create TABLE:
   CREATE  TABLE <table name>
   (column 1 datatype(size),
    column 2 datatype(size),
    .
    .
    .
    column n datatype(size);

Example: CREATE TABLE  EMP
                 (emp_id  number(10),
                  emp_name  varchar2(20),
                  salary number(10,2) );