99

-- create a table
CREATE TABLE clientmaster (cno varchar2(2),name varchar2(20),city varchar2(30),pincode varchar2(30),state varchar2(15),country varchar2(20));
create table productmaster(pno varchar2(6),pname varchar2(20),qty varchar2(8),sellprice number(8),costprice number(8));
create table salesmanmaster(cno varchar2(6),name varchar2(20),city varchar2(30),pincode varchar2(30),state varchar2(15),country varchar2(20));
ALTER TABLE clientmaster
add MOBILE_NO NUMBER(10);
alter table productmaster
add manufacturingdate date;
ALTER table productmaster
drop column manufacturingdate;
-- insert some values
INSERT INTO clientmaster values(1,'ekta','surat',395003,'gujarat','india',9904185057);
INSERT INTO clientmaster values(2,'rajesh','ahemdabad',380001,'gujarat','india',9409733084);
INSERT INTO clientmaster values(3,'hitesh','mumbai',400011,'maharashtra','india',9825906184);
INSERT INTO clientmaster values(4,'ashish','pune',411002,'maharashtra','india',9954286057);
INSERT INTO clientmaster values(5,'nayan','delhi',110001,'delhi','india',9452750867);
INSERT INTO clientmaster values(6,'pooja','surat',395003,'gujarat','india',9709433084);
INSERT INTO clientmaster values(7,'ketan','mumbai',400011,'maharashtra','india',3309497084);
INSERT INTO clientmaster values(8,'neha','surat','ahemdabad',380001,'gujarat','india',8403397094);
INSERT INTO clientmaster values(9,'jay','pune',411002,'maharashtra','india',9309632083);
INSERT INTO clientmaster values(10,'urvasi','mumbai',400011,'maharashtra','india',9209334085);
select*from clientmaster;
 INSERT INTO productmaster values(1,'buckwheat',8,800,1000);
INSERT INTO productmaster values(2,'miller',2,1500,1200);
INSERT INTO productmaster values(3,'cookies cracker',5,2000,2000);
INSERT INTO productmaster values(4,'venila wafer',15,2500,2000);
INSERT INTO productmaster values(5,'ravioli',10,1000,1500);
INSERT INTO productmaster values(6,'leoparb',18,1200,1200);
INSERT INTO productmaster values(7,'buckwheat',15,1000,1000);
INSERT INTO productmaster values(8,'miller',20,1100,2200);
INSERT INTO productmaster values(9,'cookies cracker',12,2000,2200);
select*from prodUctmaster
INSERT INTO salesmanmaster values(1,'ekta','surat',395003,'gujarat','india');
INSERT INTO salesmanmaster values(2,'rajesh','ahemdabad',380001,'gujarat','india');
INSERT INTO salesmanmaster values(3,'hitesh','mumbai',400011,'maharashtra','india');
INSERT INTO salesmanmaster values(4,'ashish','pune',411002,'maharashtra','india');
INSERT INTO salesmanmaster values(5,'nayan','delhi',110001,'delhi','india');
INSERT INTO salesmanmaster values(6,'pooja','surat',395003,'gujarat','india');
INSERT INTO salesmanmaster values(7,'ketan','mumbai',400011,'maharashtra','india');
INSERT INTO salesmanmaster values(8,'neha','surat',380001,'gujarat','india');
INSERT INTO salesmanmaster values(9,'jay','pune',411002,'maharashtra','india');
INSERT INTO salesmanmaster values(10,'urvasi','mumbai',400011,'maharashtra','india');

SELECT*FROM salesmanmaster;

SELECT name FROM clientmaster;
SELECT country FROM clientmaster;
SELECT name,city,state FROM clientmaster;
SELECT*FROM productmaster WHERE pname='buckwheat';
SELECT*FROM clientmaster WHERE city='mumbai';
SELECT*FROM salesmanmaster WHERE country='india';