ORACLE : Week # 1 Laboratory : Implementation of DDL Commands

16CACCA1CP II-B.Com (CA) INTRODUCTION TO ORACLE AND
SQL


Week # 1 Laboratory : Implementation of DDL Commands.

Date : ____________



To create a student database by using DDL commands in SQL

Source Code :

Create:

Create table karthistud(sno number(5), sname varchar(15), address varchar(30), class

varchar(10));

Desc karthistud;

Alter:

Alter table student add section varchar(10);

Desc student;




Department of Commerce, Valluvar College of Science and Management. Karur Page 1

,16CACCA1CP II-B.Com (CA) INTRODUCTION TO ORACLE AND
SQL
Modify:

Alter table karthistud modify class varchar(15);

Desc karthistud;



Drop column:

Alter table karthistud drop column address;

Desc karthistud;




Department of Commerce, Valluvar College of Science and Management. Karur Page 2

,16CACCA1CP II-B.Com (CA) INTRODUCTION TO ORACLE AND
SQL


Rename:

Rename karthistud to karthistudent;

Desc karthistud;

Desc karthistudent;



Drop table:

Drop table karthistudent;

Desc karthistudent;




Department of Commerce, Valluvar College of Science and Management. Karur Page 3

, 16CACCA1CP II-B.Com (CA) INTRODUCTION TO ORACLE AND
SQL


Extra Credit:

To create a employee database and implement DDL commands.




Department of Commerce, Valluvar College of Science and Management. Karur Page 4