SQL DDL COMMANDS DML COMMANDS TCL COMMANDS FIBONACCI SERIES FACTORIAL STRING REVERSE SUM OF SERIES PL/SQL TRIGGER CURSOR STUDENT MA...
Showing posts with label Database Management Systems Lab. Show all posts
Showing posts with label Database Management Systems Lab. Show all posts
SUM OF SERIES
Database Management Systems Lab
AIM: To find the sum of series in SQL. ALGORITHM: Step 1: Start the program. Step 2: Get the number of terms n. Step 3: Start the l...
REVERSING A GIVEN STRING
Database Management Systems Lab
8 AIM: To reverse a string in SQL. ALGORITHM: Get the input string. Find the length of the string. Extract the char one by one from ...
FACTORIAL OF THE GIVEN NUMBER
Database Management Systems Lab
AIM: To write PL/SQL program using function and procedure.. ALGORITHM: Algorithm for main function: Step 1: Accept he value of n in th...
FIBONACCI SERIES
Database Management Systems Lab
AIM: To find the Fibonacci series of the give number using sql program. ALGORITHM: Step 1: Start Step 2: Get the no of terms n in the...
LIBRARY MANAGEMENT SYSTEM
Database Management Systems Lab
CREATION SQL> create table lib ( bookname varchar(15),author varchar(15), publicationvarchar(10),...
STUDENT MARK ANALYSIS
Database Management Systems Lab
CREATE SQL> create table student00(rollno number primary key,name varchar(15),age number,sex char...
STUDENT MARK ANALYSIS USING CURSOR
Database Management Systems Lab
TABLE CREATION: SQL>CREATE TABLE STU(STUNO NUMBER(10),STUNAME VARCHAR(15),STUSTATUS VARCHAR(10)...
TRIGGER
Database Management Systems Lab
TABLE CREATION: SQL>create table employee(empname varchar(10),empno number(10),job varchar(10),s...
TCL COMMANDS
Database Management Systems Lab
TABLE CREATION: SQL>CREATE TABLE students(s_id number(10),s_name varchar(15),s_dob date, status...
DML COMMANDS
Database Management Systems Lab
TABLE CREATION: SQL>CREATE TABLE employee(e_no number(10),e_name varchar(15),e_age number(5),d_...
DDL COMMANDS
Database Management Systems Lab
TABLE CREATION: CREATE TABLE employeerecord(employee_no number(5),employee_name varchar(15),departme...
Subscribe to:
Posts (Atom)