SRI RAMAKRISHNA MISSION VIDYALAYA
COLLEGE OF ARTS AND SCIENCE
[AUTONOMOUS]
Re-Accredited by NAAC with A+ Grade
Coimbatore – 641 020
APRIL – 2024
DEPARTMENT OF COMPUTER
APPLICATIONS NAME :
REG. NO :
SEMESTER : IV
SUBJECT : RDBMS LAB
SUBJECT CODE: 22UCA4CP5
, SRI RAMAKRISHNA MISSION VIDYALAYA
COLLEGE OF ARTS AND SCIENCE
[AUTONOMOUS]
Re-Accredited by NAAC with A+ Grade
Coimbatore – 641 020
DEPARTMENT OF COMPUTER
APPLICATIONS BONAFIDE
CERTIFICATE
This is certify that it is a Bonafide record work done by
_ _ in "RDBMS LAB"
for the IV Semester during the academic year 2023-2024
Submitted for the Semester Practical Examinations held on _ _
.
Staff in Charge Head of the Department
Internal Examiner External Examiner
, INDEX
PAGE
S.NO DATE PARTICULARS SIGN
NO
1 DDL Commands
2 DML Commands
Relational operators and
3
Logical operators
Set, Grouping and Sorting
4
operator
5 Count and Character function
6 Number and Date Function
7 Aggregate Functions
Create Passenger table with
8 PL/SQL Procedure to print details
of the entire Passenger
9 Factorial usingPL/SQL
10 Fibonacci series using PL/SQL
11 Arithmetic operations using
PL/SQL
12 Looping statements in PL/SQL
13 Area of Circle
14 Ticket fare calculation using
PL/SQL
15 Current stock using PL/SQL
, EX NO: 1
1.DDL COMMANDS
DATE:
Aim:
To explore the Simple queries with DDL Commands using SQL.
Algorithm:
Step 1:Start the Process
Step 2:create a table using create statement: create table
table_name (column _name1 data constraints,
column_name 2 data_type
constraints)
Step 3:alter the table using by using alter command
Add:
To add column: alter table table_name ADD column_namedatatype
Modify:
To modify a column: alter table table_name
MODIFY column_namedatatype
Step 4:drop the table using drop
command Drop table
table_name
Step 5: Stop the Process
COLLEGE OF ARTS AND SCIENCE
[AUTONOMOUS]
Re-Accredited by NAAC with A+ Grade
Coimbatore – 641 020
APRIL – 2024
DEPARTMENT OF COMPUTER
APPLICATIONS NAME :
REG. NO :
SEMESTER : IV
SUBJECT : RDBMS LAB
SUBJECT CODE: 22UCA4CP5
, SRI RAMAKRISHNA MISSION VIDYALAYA
COLLEGE OF ARTS AND SCIENCE
[AUTONOMOUS]
Re-Accredited by NAAC with A+ Grade
Coimbatore – 641 020
DEPARTMENT OF COMPUTER
APPLICATIONS BONAFIDE
CERTIFICATE
This is certify that it is a Bonafide record work done by
_ _ in "RDBMS LAB"
for the IV Semester during the academic year 2023-2024
Submitted for the Semester Practical Examinations held on _ _
.
Staff in Charge Head of the Department
Internal Examiner External Examiner
, INDEX
PAGE
S.NO DATE PARTICULARS SIGN
NO
1 DDL Commands
2 DML Commands
Relational operators and
3
Logical operators
Set, Grouping and Sorting
4
operator
5 Count and Character function
6 Number and Date Function
7 Aggregate Functions
Create Passenger table with
8 PL/SQL Procedure to print details
of the entire Passenger
9 Factorial usingPL/SQL
10 Fibonacci series using PL/SQL
11 Arithmetic operations using
PL/SQL
12 Looping statements in PL/SQL
13 Area of Circle
14 Ticket fare calculation using
PL/SQL
15 Current stock using PL/SQL
, EX NO: 1
1.DDL COMMANDS
DATE:
Aim:
To explore the Simple queries with DDL Commands using SQL.
Algorithm:
Step 1:Start the Process
Step 2:create a table using create statement: create table
table_name (column _name1 data constraints,
column_name 2 data_type
constraints)
Step 3:alter the table using by using alter command
Add:
To add column: alter table table_name ADD column_namedatatype
Modify:
To modify a column: alter table table_name
MODIFY column_namedatatype
Step 4:drop the table using drop
command Drop table
table_name
Step 5: Stop the Process
