Oracle SQL Practical 1st class

DBMS Lab 1st Class as per NEP Syllabus BSc 2nd year 4th Semester.

SQL Queries used in this videos are in the following document.
1. Create a table called employee with the following structure:
Column Name Domain Type
Empno Number
Ename Varchar2(20)
Job Varchar2(20)
Mgr Number
Salary number

create table employee
(empno number(5),
Ename varchar2(20),
job varchar2(20),
mgr number(5),
salary number(10,2));

a. Add a column commission with domain to the employee table
alter table employee add (commission number(2));

b. Insert any five records into the table
insert into employee values (20001,'Sidrama', 'Associate Professor', 20001, 84000,10);
insert into employee values (20003,'Channakeshava', 'Assistant Professor', 20001, 54000,25);
insert into employee values (20005,'Himantharaja', 'Manager', 20001, 48000,15);
insert into employee values (20008,'Yashodhara', 'FDA', 20005, 44000,8);
insert into employee values (20009,'Bhagyashree', 'Faculty', 20003, 34000,12);
insert into employee values (20006,'Mohiyuddin khan', 'Faculty', 20003, 34000,16);

c. Update the column details of job
Update employee set job = 'Superintendent' where empno=20008;

d. Rename column of employee table using alter command.
alter table employee rename column job to designation;

e. Delete the employee whose empno is 19. (we will delete 20006)
delete from employee where empno=20006;

Additional Commands:
1. Display all the tables for current user
Select * from tab;
2. View the structure of the table
Describe employee;
3. Setting line size wide:
Set linesize 200;
4. Display the content of table
Select * from employee
5. Save the instance:
Commit;
6. Revert to last saved position:
Rollback;