CREATE TABLE college(sno number(2),Eno number(11),Sname char(20),DOB date,gender char(5),Mno number(10),email varchar(30),address varchar(30));
INSERT into college(sno,ENo,Sname,DOB,gender,Mno,email,address)values(1,20215002717,'sarthak',1999-05-05,'M',7654890235,'msithostel123@gmail.com','204-msi hostel');
INSERT into college values(2,3546789091,'aditya',1998-07-30,'m',9087658906,'naughtyaditya@gmail.com','c2 janankpuri');
INSERT into college values(3,3546789456,'ben',1998-05-23,'m',7658932323,'benstokes12@gmail.com','a4 vikaspuri');
INSERT into college values(4,2546789092,'aayush',2008-04-14,'m',9871145312,'aayushl@gmail.com','jhopdi mumbai');
INSERT into college values(5,1042357893,'disha patani',1993-02-12,'f',8765432132,'ckts@gmail.com','tiger house');
INSERT into college values(6,9856741234,'deepika',1999-02-14,'f',9871236540,'deepveer22@gmail.com','ameer gali lucknow');
INSERT into college values(7,34515002717,'sana',1992-11-3,'f',7811425656,'sanakhan321@gmail.com','block c2 south mumbai');
select * from college;
CREATE TABLE bank(empno number(2),ename char(20),street char(30),city char(10),DOJ date,desg char(15),salary number(7));
INSERT into bank(empno,ename,street,city,DOJ,desg,salary)values(1,'david','gali number 2','boston',2000-07-21,'manager',60000);
INSERT into bank values(2,'AFROJACK','KHOLI NUMBER 55','NEWYORK',1999-11-01,' JR.manager',55000);
INSERT into bank values(3,'alesso','walstreet','london',2000-01-15,'HR executive',75000);
INSERT into bank values(4,'martin','32-linker','los angeles',1998-03-14,' Sr.manager',80000);
INSERT into bank values(5,'yellowclaw','52-biker','las vegas',2004-06-22,' CTO',51000);
INSERT into bank values(6,'nucleyA','raajghat ','mumbai',2001-10-02,'vice president ',90000);
INSERT into bank values(7,'avicii','10 downing street','new jersey',1995-12-20,' president',95000);
select *from bank;