Notes

create table employ(
empid number(5) primary key,
empname varchar(20),
empdep varchar(5) check (empdep IN('cs','it','me','ec'),
empsalary number(10));

insert into employ values(1,'prateek','cs',10000);

insert into employ values(2,'akash','cs',9000);

insert into employ values(3,'Happy','me',8000);

insert into employ values(4,'johny','it',7000);

select * from employ where empdep='cs';

select empname from employ where empname like'a%' or like'j%';



select

select empdept from employ where empdept=*;

create table student(
rollno number(5),
name varchar(20),
branch char(5));

insert into student values(1,'Prateek','cs');

insert into student values(2,'Nutan','cs');

insert into student values(3,'Happy','cs');

insert into student values(4,'Vikas','cs');

create table result(
rollno number(5),
sem varchar(5),
precentage number(3,2));

SELECT * FROM student NATURAL JOIN result;

SELECT * FROM student s LEFT OUTER JOIN result r ON (s.rollno=r.rollno);

SELECT * FROM student s RIGHT OUTER JOIN result r
ON(s.rollno=r.rollno);

SELECT * FROM student s
FULL OUTER JOIN result r ON(s.rollno=r.rollno);