DATA DEFINATION LANGUAGE (DDL) COMMANDS

Create a table called STUDENT with columns: SID (NUMBER) , SNAME (VARCHAR2(30)) , AGE (NUMBER) , COURSE (VARCHAR2(20))

Create a table EMPLOYEE with columns: EID NUMBER , ENAME VARCHAR2(40) , SALARY NUMBER(8,2) , DEPTNO NUMBER

Create a table DEPARTMENT with columns: DEPTNO NUMBER , DNAME VARCHAR2(30) , LOCATION VARCHAR2(30)

Create a table BOOK with columns: BOOK_ID NUMBER , TITLE VARCHAR2(50) , AUTHOR VARCHAR2(40) , PRICE NUMBER

Create a table COURSE with columns: CID NUMBER , CNAME VARCHAR2(40) , DURATION NUMBER

Create a table PROJECT with columns: PID NUMBER , PNAME VARCHAR2(50) , START_DATE DATE , END_DATE DATE

Create a table CUSTOMER with columns: CID NUMBER , CNAME VARCHAR2(40) , CITY VARCHAR2(30) , PHONE NUMBER

Create a table SALES with columns: SALE_ID NUMBER , PRODUCT_NAME VARCHAR2(50) , QUANTITY NUMBER , PRICE NUMBER

Create a table EMP_COPY from the existing EMP table (structure only)

Create a table EMP_BACKUP from EMP including data

Add a column EMAIL VARCHAR2(50) to the STUDENT table

Add a column PHONE NUMBER to the EMPLOYEE table

Modify the column SNAME in STUDENT table to VARCHAR2(50)

Modify the column SALARY in EMPLOYEE table to NUMBER(10,2)

Add two columns CITY VARCHAR2(30) and PINCODE NUMBER to CUSTOMER table

Rename the column SNAME to STUDENT_NAME in STUDENT table

Drop the column AGE from STUDENT table

Set the column SALARY in EMPLOYEE table to NOT NULL

Increase the size of column TITLE in BOOK table to VARCHAR2(100)

Add a column MANAGER_ID NUMBER to EMPLOYEE table

Drop the table STUDENT

Drop the table CUSTOMER from the database

Drop the table PROJECT permanently

Remove the table SALES

Drop the table COURSE

Rename the table STUDENT to STUDENTS

Rename the table EMPLOYEE to EMP_MASTER

Rename the table CUSTOMER to CLIENT

Rename the table BOOK to BOOK_DETAILS

Rename the table PROJECT to PROJECT_INFO

Remove all records from the STUDENT table

Delete all rows from EMPLOYEE table using TRUNCATE

Empty the CUSTOMER table quickly

Remove all data from SALES table but keep structure

Clear the PROJECT table

Create a table TRAINING with columns TID , TNAME , DURATION

Add column TRAINER_NAME VARCHAR2(40) to TRAINING

Modify TNAME column size to VARCHAR2(60)

Rename the TRAINING table to TRAINING_PROGRAM

Truncate the TRAINING_PROGRAM table

Drop the TRAINING_PROGRAM table

Create a table EMP_PROJECT with the following columns

EMP_ID NUMBER , PROJECT_ID NUMBER , START_DATE DATE , END_DATE DATE , ROLE VARCHAR2(30)

Later modify the table to increase the size of ROLE to VARCHAR2(50) and add a column STATUS VARCHAR2(20)

Create a table PRODUCT with columns

PID NUMBER , PNAME VARCHAR2(50) , PRICE NUMBER , CATEGORY VARCHAR2(30)

Then rename column PNAME to PRODUCT_NAME and change PRICE datatype to NUMBER(10,2)

Create a table ORDERS with columns

ORDER_ID NUMBER , CUSTOMER_ID NUMBER , ORDER_DATE DATE , TOTAL_AMOUNT NUMBER

After creation:

* Add column STATUS VARCHAR2(20)

* Drop column TOTAL_AMOUNT

* Add column TOTAL_AMOUNT NUMBER(10,2) again

Create a table EMP_TEMP from the EMP table containing only employees with salary greater than 2000

Then:

* Rename the table to EMP_HIGH_SALARY

* Truncate the table

* Drop the table

Create a table STUDENT_RECORD with columns

SID NUMBER , SNAME VARCHAR2(40) , COURSE VARCHAR2(30) , MARKS NUMBER

Then perform the following:

* Add column GRADE CHAR(1)

* Modify MARKS datatype to NUMBER(5,2)

* Rename column COURSE to COURSE_NAME

Create a table EMP_ARCHIVE using the structure of the EMP table but without copying data

Then:

* Add column ARCHIVE_DATE DATE

* Rename the table to EMP_HISTORY

Create a table DEPT_BACKUP from DEPT table including all rows

Then:

* Drop column LOC

* Add column LOCATION VARCHAR2(40)

Create a table SALES_DATA with columns

SALE_ID NUMBER , PRODUCT_ID NUMBER , SALE_DATE DATE , AMOUNT NUMBER

Then perform:

* Add column REGION VARCHAR2(30)

* Modify AMOUNT to NUMBER(12,2)

* Rename the table to REGIONAL_SALES_DATA

Create a table LOG_TABLE with columns

LOG_ID NUMBER , USER_NAME VARCHAR2(30) , ACTION VARCHAR2(50) , LOG_DATE DATE

Then:

* Truncate the table

* Rename it to SYSTEM_LOG

* Drop it permanently