Sunday, May 27, 2012
DBMS Sample Project Part-2
Creating Tables and Inserting Records
create table COMPANY_CLIENT(cname varchar2(50),
cregno varchar2(20) primary key,
cesyr int,
cphno# int,
cfno int,
cemail varchar2(50),
clocat varchar2(50),
pcode varchar2(20));
insert into COMPANY_CLIENT values('maruthi',
'c101',
1987,
01112345678,
01112345679,
'maruthi@yahoo.com',
'delhi',
'c3');
insert into COMPANY_CLIENT values('zen',
'c201',
1980,
01112345680,
01112345681,
'zen@yahoo.com',
'delhi',
'c3');
insert into COMPANY_CLIENT values('hcl',
'c301',
1972,
02212345678,
02212345679,
'hcl@yahoo.com',
'bombay',
'l12');
insert into COMPANY_CLIENT values('dell',
'c401',
1982,
02212345680,
02212345681,
'dell@yahoo.com',
'bombay',
'l12');
insert into COMPANY_CLIENT values('bajaj',
'c501',
1983,
04412345678,
04412345679,
'bajaj@yahoo.com',
'banglore',
's19');
insert into COMPANY_CLIENT values('herohonda',
'c601',
1984,
04412345680,
04412345681,
'honda@yahoo.com',
'banglore',
's19');
insert into COMPANY_CLIENT values('pepsi',
'c701',
1989,
05512345678,
05512345679,
'pepsi@yahoo.com',
'calcutta',
'd4');
insert into COMPANY_CLIENT values('cocacola',
'c801',
1979,
05512345680,
05512345681,
'cola@yahoo.com',
'calcutta',
'd4');
insert into COMPANY_CLIENT values('reynolds',
'c901',
1994,
04012345678,
04012345679,
'ren@yahoo.com',
'hyderabad',
'p16');
insert into COMPANY_CLIENT values('cello',
'c111',
19985,
04012345680,
04012345681,
'cello@yahoo.com',
'hyderabad',
'p16');
insert into COMPANY_CLIENT values('parle',
'c222',
1988,
05412345678,
05412345679,
'parle@yahoo.com',
'chennai',
'b2');
insert into COMPANY_CLIENT values('britania',
'c333',
2001,
05412345680,
05412345681,
'bri@yahoo.com',
'chennai',
'b2');
---------------------------------------------------
create table PRODUCT(pname varchar2(10),
pcode varchar2(5),
ppriceapproxrs int,
pweight numeric(5,2));
insert into PRODUCT values('car',
'c3',
300000,
250.00);
insert into PRODUCT values('laptop',
'l12',
45000,
003.00);
insert into PRODUCT values('scooter',
's19',
40000,
100.00);
insert into PRODUCT values('drinks',
'd4',
20,
000.60);
insert into PRODUCT values('pen',
'p16',
15,
000.10);
insert into PRODUCT values('biscut',
'b2',
20,
000.25);
--------------------------------------------------------
create table AD_COMPANY(aname varchar2(20),
aregno varchar2(5) primary key,
aowner varchar2(10),
aesyr int,
aphno# int,
afno int,
aemail varchar2(20),
alocat varchar2(10));
insert into AD_COMPANY values('mother_ad_ageccy',
'A007',
'reniguntla',
1980,
05598765432,
05598765433,
'mother@yahoo,com',
'calcutta');
create table AD_BRANCH(bcode varchar2(5) primary key,
besyr int,
bphno# int,
bfno int,
blocat varchar2(10),
aregno varchar2(5));
insert into AD_BRANCH values('b1',
1981,
01112345690,
01112345691,
'delhi',
'A007');
insert into AD_BRANCH values('b2',
1983,
02212345690,
02212345691,
'bombay',
'A007');
insert into AD_BRANCH values('b3',
1986,
04412345690,
04412345691,
'banglore',
'A007');
insert into AD_BRANCH values('b4',
1989,
05512345690,
05512345691,
'calcutta',
'A007');
insert into AD_BRANCH values('b5',
1999,
04012345690,
04012345691,
'hyderabad',
'A007');
insert into AD_BRANCH values('b6',
2001,
05412345690,
05412345691,
'chennai',
'A007');
------------------------------------------------------------
create table DEPARTMENT(dname varchar2(10),
dcode varchar2(5) primary key,
dphno# int,
dfno int);
insert into DEPARTMENT values('cusreldep1',
'b11',
01112345692,
01112345693);
insert into DEPARTMENT values('finance1',
'b12',
01112345694,
01112345695);
insert into DEPARTMENT values('creative1',
'b13',
01112345696,
01112345697);
insert into DEPARTMENT values('cusreldep2',
'b21',
02212345692,
02212345693);
insert into DEPARTMENT values('finance2',
'b22',
02212345694,
02212345695);
insert into DEPARTMENT values('creative2',
'b23',
02212345696,
02212345697);
insert into DEPARTMENT values('cusreldep3',
'b31',
04412345694,
04412345695);
insert into DEPARTMENT values('finance3',
'b32',
04412345696,
04412345697);
insert into DEPARTMENT values('creative3',
'b33',
04412345692,
04412345693);
insert into DEPARTMENT values('cusreldep4',
'b41',
05512345692,
05512345693);
insert into DEPARTMENT values('finance4',
'b42',
05512345694,
05512345695);
insert into DEPARTMENT values('creative4',
'b43',
05512345696,
05512345697);
insert into DEPARTMENT values('cusreldep5',
'b51',
04012345692,
04012345693);
insert into DEPARTMENT values('finance5',
'b52',
04012345694,
04012345695);
insert into DEPARTMENT values('creative5',
'b53',
04012345696,
04012345697);
insert into DEPARTMENT values('cusreldep6',
'b61',
05412345692,
05412345693);
insert into DEPARTMENT values('finance6',
'b62',
05412345694,
05412345695);
insert into DEPARTMENT values('creative6',
'b63',
05412345696,
05412345697);
----------------------------------------------------------
create table HAVE(bcode varchar2(5),
dcode varchar2(5),
primary key(bcode, dcode));
insert into HAVE values('b1','b11');
insert into HAVE values('b1','b12');
insert into HAVE values('b1','b13');
insert into HAVE values('b2','b21');
insert into HAVE values('b2','b22');
insert into HAVE values('b2','b23');
insert into HAVE values('b3','b31');
insert into HAVE values('b3','b32');
insert into HAVE values('b3','b33');
insert into HAVE values('b4','b41');
insert into HAVE values('b4','b42');
insert into HAVE values('b4','b43');
insert into HAVE values('b5','b51');
insert into HAVE values('b5','b52');
insert into HAVE values('b5','b53');
insert into HAVE values('b6','b61');
insert into HAVE values('b6','b62');
insert into HAVE values('b6','b63');
-------------------------------------------------------------
create table CUS_REL_DEPT(cusdname varchar2(10),
cusdcode varchar2(5) primary key,
cusdphno# int,
cusdfno int);
insert into CUS_REL_DEPT values('cusreldep1',
'b11',
01112345692,
01112345693);
insert into CUS_REL_DEPT values('cusreldep2',
'b21',
02212345692,
02212345693);
insert into CUS_REL_DEPT values('cusreldep3',
'b31',
04412345694,
04412345695);
insert into CUS_REL_DEPT values('cusreldep4',
'b41',
05512345692,
05512345693);
insert into CUS_REL_DEPT values('cusreldep5',
'b51',
04012345692,
04012345693);
insert into CUS_REL_DEPT values('cusreldep6',
'b61',
05412345692,
05412345693);
------------------------------------------------------
create table CONSULT(cusdcode varchar2(5),
cregno varchar2(5),
primary key(cusdcode,cregno));
insert into CONSULT values('b11','c101');
insert into CONSULT values('b11','c333');
insert into CONSULT values('b21','c201');
insert into CONSULT values('b21','c222');
insert into CONSULT values('b31','c301');
insert into CONSULT values('b31','c111');
insert into CONSULT values('b41','c401');
insert into CONSULT values('b41','c901');
insert into CONSULT values('b51','c501');
insert into CONSULT values('b51','c801');
insert into CONSULT values('b61','c601');
insert into CONSULT values('b61','c701');
create table FINANCE_DEPT(fdname varchar2(10),
fdcode varchar2(5) primary key,
fdphno# int,
fdfno int,
acode varchar2(5));
insert into FINANCE_DEPT values('finance1',
'b12',
01112345694,
01112345695,
'a1');
insert into FINANCE_DEPT values('finance2',
'b22',
02212345694,
02212345695,
'a2');
insert into FINANCE_DEPT values('finance3',
'b32',
04412345696,
04412345697,
'a3');
insert into FINANCE_DEPT values('finance4',
'b42',
05512345694,
05512345695,
'a4');
insert into FINANCE_DEPT values('finance5',
'b52',
04012345694,
04012345695,
'a5');
insert into FINANCE_DEPT values('finance6',
'b62',
05412345694,
05412345695,
'a6');
create table CREATIVE_DEPT(cdname varchar2(10),
cdcode varchar2(5) primary key,
cdphno# int,
cdfno int);
insert into CREATIVE_DEPT values('creative1',
'b13',
01112345696,
01112345697);
insert into CREATIVE_DEPT values('creative2',
'b23',
02212345696,
02212345697);
insert into CREATIVE_DEPT values('creative3',
'b33',
04412345692,
04412345693);
insert into CREATIVE_DEPT values('creative4', 'b4
05512345696,
05512345697);
insert into CREATIVE_DEPT values('creative5',
'b53',
04012345696,
04012345697);
insert into CREATIVE_DEPT values('creative6',
'b63',
05412345696,
05412345697);
-----------------------------------------------------------------
create table ACCOUNT_SEC(acode varchar2(5),
adcost int,
balan int,
ldate date,
cregno varchar2(5),
primary key(acode,cregno));
insert into ACCOUNT_SEC values('a1',
3000000,
1500000,
'1-jan-08',
'c101');
insert into ACCOUNT_SEC values('a1',
600000,
300000,
'25-dec-07',
'c333');
insert into ACCOUNT_SEC values('a2',
3000000,
1500000,
'1-dec-07',
'c201');
insert into ACCOUNT_SEC values('a2',
600000,
300000,
'5-dec-07',
'c222');
insert into ACCOUNT_SEC values('a3',
2500000,
1200000,
'25-dec-07',
'c301');
insert into ACCOUNT_SEC values('a3',
500000,
200000,
'28-nov-07',
'c111');
insert into ACCOUNT_SEC values('a4',
2500000,
1200000,
'25-nov-07',
'c401');
insert into ACCOUNT_SEC values('a4',
500000,
200000,
'2-feb-08',
'c901');
insert into ACCOUNT_SEC values('a5',
2000000,
1000000,
'1-feb-08',
'c501');
insert into ACCOUNT_SEC values('a5',
1000000,
500000,
'14-feb-08',
'c801');
insert into ACCOUNT_SEC values('a6',
2000000,
1000000,
'6-jan-08',
'c601');
insert into ACCOUNT_SEC values('a6',
1000000,
500000,
'24-mar-08',
'c701');
------------------------------------------------------------------
create table PRODUCTION_STUDIO(stname varchar2(15),
stregno varchar2(5) primary key,
stphno# int,
ststreet varchar2(15),
stcity varchar2(10),
stpin int,
cdcode varchar2(5));
insert into PRODUCTION_STUDIO values('konika_studio',
'st101',
01198765432,
'cnnaughtplace',
'delhi',
110023,
'b13');
insert into PRODUCTION_STUDIO values('komal__studio',
'st102',
01198765433,
'nehruplace',
'delhi',
110024,'b13');
insert into PRODUCTION_STUDIO values('shivaji__studio',
'st103',
02298765432,
'shivajinagar',
'bombay',
220037,
'b23');
insert into PRODUCTION_STUDIO values('chatrapathi_std',
'st104',
02298765433,
'bandra',
'bombay',
220038,
'b23');
insert into PRODUCTION_STUDIO values('bang_studio',
'st105',
04498765433,
'karunanagar',
'banglore',
220038,
'b33');
insert into PRODUCTION_STUDIO values('padmakshi_std',
'st106',
04498765434,
'mahanagar',
'banglore',
220049,
'b33');
insert into PRODUCTION_STUDIO values('netaji_studio',
'st107',
05598765434,
'therisanagar',
'calcutta',
550666,
'b43');
insert into PRODUCTION_STUDIO values('subhash_studio',
'st108',
05598765435,
'netajinagar',
'calcutta',
550777,
'b43');
insert into PRODUCTION_STUDIO values('annapurna_std',
'st109',
04098765435,
'banjarahills',
'hyderabad',
800056,
'b53');
insert into PRODUCTION_STUDIO values('ramoji_studio',
'st110',
04098765436,
'jublihills',
'hyderabad',
800057,
'b53');
insert into PRODUCTION_STUDIO values('padmalaya_std',
'st111',
05498765436,
'nugambakkam',
'chennai',
054678,
'b63');
insert into PRODUCTION_STUDIO values('chennai_std',
'st112',
05498765437,
'madhuranagar',
'chennai',
054679,
'b63');
----------------------------------------------------------------------
create table EMPLOYEE1(ename varchar2(10),
eid varchar2(5) primary key,
edesig varchar2(5),
eexyr int,
esal int,
edob date,
elocat varchar2(10),
dcode varchar2(5),
bcode varchar2(5));
insert into EMPLOYEE1 values('raghu',
'e1',
'crm',
2,
22000,
'6-may-79',
'delhi',
'b11',
'b1');
insert into EMPLOYEE1 values('thirupati',
'e2',
'emp',
2,
22000,
'6-may-79',
'delhi',
'b11',
'b1');
insert into EMPLOYEE1 values('safi',
'e3',
'fm',
7,
25000,
'12-nov-71',
'delhi',
'b12',
'b1');
insert into EMPLOYEE1 values('sandya',
'e4',
'emp',
1,
35000,
'12-feb-81',
'delhi',
'b12',
'b1');
insert into EMPLOYEE1 values('divya',
'e5',
'cd',
6,
32000,
'24-mar-1985',
'delhi',
'b13',
'b1');
insert into EMPLOYEE1 values('laxmi',
'e6',
'emp',
3,
23000,
'6-may-81',
'delhi',
'b13',
'b1');
insert into EMPLOYEE1 values('rama',
'e7',
'crm',
2,
16000,
'1-aug-71',
'bombay',
'b21',
'b2');
insert into EMPLOYEE1 values('amith',
'e8',
'emp',
6,
35000,
'12-feb-81',
'bombay',
'b21',
'b2');
insert into EMPLOYEE1 values('neema',
'e9',
'fm',
5,
25000,
'23-apr-79',
'bombay',
'b22',
'b2');
insert into EMPLOYEE1 values('saurab',
'e10',
'emp',
3,
22000,
'30-jan-87',
'bombay',
'b22',
'b2');
insert into EMPLOYEE1 values('sandeep',
'e11',
'cd',
7,
35000,
'14-oct-81',
'bombay',
'b23',
'b2');
insert into EMPLOYEE1 values('vivek',
'e12',
'emp',
3,
32000,
'2-oct-82',
'bombay',
'b23',
'b2');
insert into EMPLOYEE1 values('rahul',
'e13',
'crm',
5,
23000,
'23-mar-83',
'banglore',
'b31',
'b3');
insert into EMPLOYEE1 values('mukesh',
'e14',
'emp',
3,
23000,
'29-sep-78',
'banglore',
'b31',
'b3');
insert into EMPLOYEE1 values('satya',
'e15',
'fm',
5,
29000,
'19-mar-79',
'banglore',
'b32',
'b3');
insert into EMPLOYEE1 values('naresh',
'e16',
'emp',
3,
25000,
'12-mar-79',
'banglore',
'b32',
'b3');
insert into EMPLOYEE1 values('nareen',
'e17',
'cd',
5,
35000,
'6-jun-72',
'banglore',
'b33',
'b3');
insert into EMPLOYEE1 values('bhagya',
'e18',
'emp',
2,
21000,
'17-apr-81',
'banglore',
'b33',
'b3');
insert into EMPLOYEE1 values('roja',
'e19',
'crm',
3,
27000,
'5-sep-79',
'calcutta',
'b41',
'b4');
insert into EMPLOYEE1 values('lalitha',
'e20',
'emp',
4,
22000,
'6-sep-81',
'calcutta',
'b41',
'b4');
insert into EMPLOYEE1 values('latha',
'e21',
'fm',
3,
29000,
'7-may-82',
'calcutta',
'b42',
'b4');
insert into EMPLOYEE1 values('amul',
'e22',
'emp',
4,
30000,
'15-aug-77',
'calcutta',
'b42',
'b4');
insert into EMPLOYEE1 values('sunil',
'e23',
'cd',
3,
40000,
'14-nov-81',
'calcutta',
'b43',
'b4');
insert into EMPLOYEE1 values('susheel',
'e24',
'emp',
6,
23000,
'3-mar-71',
'calcutta',
'b43',
'b4');
insert into EMPLOYEE1 values('ram',
'e25',
'crm',
2,
29000,
'25-dec-60',
'hyderabad',
'b51',
'b5');
insert into EMPLOYEE1 values('krishna',
'e26',
'emp',
6,
22000,
'23-aug-67',
'hyderabad',
'b51',
'b5');
insert into EMPLOYEE1 values('anir',
'e27',
'fm',
4,
26000,
'11-aug-78',
'hyderabad',
'b52',
'b5');
insert into EMPLOYEE1 values('rajini',
'e28',
'emp',
4,
25000,
'22-feb-79',
'hyderabad',
'b52',
'b5');
insert into EMPLOYEE1 values('suresh',
'e29',
'cd',
4,
32000,
'14-feb-72',
'hyderabad',
'b53',
'b5');
insert into EMPLOYEE1 values('sreenu',
'e30',
'emp',
3,
23000,
'30-jan-75',
'hyderabad',
'b53',
'b5');
insert into EMPLOYEE1 values('venky',
'e31',
'crm',
3,
23000,
'23-dec-73',
'chennai',
'b61',
'b6');
insert into EMPLOYEE1 values('deva',
'e32',
'emp',
4,
24000,
'23-nov-73',
'chennai',
'b61',
'b6');
insert into EMPLOYEE1 values('chakri',
'e33',
'fm',
5,
25000,
'22-feb-81',
'chennai',
'b62',
'b6');
insert into EMPLOYEE1 values('kiran',
'e34',
'emp',
4,
26000,
'22-feb-72',
'chennai',
'b62',
'b6');
insert into EMPLOYEE1 values('sagar',
'e35',
'cd',
3,
29000,
'29-mar-71',
'chennai',
'b63',
'b6');
insert into EMPLOYEE1 values('nikhil',
'e36',
'emp',
4,
30000,
'15-nov-76',
'chennai',
'b63',
'b6');
insert into EMPLOYEE1 values('john',
'e37',
'mgr',
4,
40000,
'1-jan-71',
'delhi',
'b1',
'b1');
insert into EMPLOYEE1 values('mathew',
'e38',
'mgr',
4,
45000,
'2-feb-72',
'bombay',
'b2',
'b2');
insert into EMPLOYEE1 values('martin',
'e39',
'mgr',
2,
30000,
'3-mar-76',
'banglore',
'b3',
'b3');
insert into EMPLOYEE1 values('dick',
'e40',
'mgr',
2,
40000,
'3-apr-76',
'calcutta',
'b4',
'b4');
insert into EMPLOYEE1 values('tom',
'e41',
'mgr',
3,
40000,
'4-apr-71',
'hyderabad',
'b5',
'b5');
insert into EMPLOYEE1 values('harry',
'e42',
'mgr',
1,
35000,
'5-oct-71',
'chennai',
'b6',
'b6');
-----------------------------------------------------------------
create table EMPLOYEE2(eid varchar2(5) primary key,
esex varchar2(5));
insert into EMPLOYEE2 values('e1','m');
insert into EMPLOYEE2 values('e2','m');
insert into EMPLOYEE2 values('e3','m');
insert into EMPLOYEE2 values('e4','f');
insert into EMPLOYEE2 values('e5','f');
insert into EMPLOYEE2 values('e6','f');
insert into EMPLOYEE2 values('e7','f');
insert into EMPLOYEE2 values('e8','m');
insert into EMPLOYEE2 values('e9','f');
insert into EMPLOYEE2 values('e10','m');
insert into EMPLOYEE2 values('e11','m');
insert into EMPLOYEE2 values('e12','m');
insert into EMPLOYEE2 values('e13','m');
insert into EMPLOYEE2 values('e14','m');
insert into EMPLOYEE2 values('e15','m');
insert into EMPLOYEE2 values('e16','m');
insert into EMPLOYEE2 values('e17','m');
insert into EMPLOYEE2 values('e18','f');
insert into EMPLOYEE2 values('e19','f');
insert into EMPLOYEE2 values('e20','f');
insert into EMPLOYEE2 values('e21','f');
insert into EMPLOYEE2 values('e22','m');
insert into EMPLOYEE2 values('e23','m');
insert into EMPLOYEE2 values('e24','m');
insert into EMPLOYEE2 values('e25','m');
insert into EMPLOYEE2 values('e26','m');
insert into EMPLOYEE2 values('e27','m');
insert into EMPLOYEE2 values('e28','f');
insert into EMPLOYEE2 values('e29','m');
insert into EMPLOYEE2 values('e30','m');
insert into EMPLOYEE2 values('e31','m');
insert into EMPLOYEE2 values('e32','m');
insert into EMPLOYEE2 values('e33','m');
insert into EMPLOYEE2 values('e34','m');
insert into EMPLOYEE2 values('e35','m');
insert into EMPLOYEE2 values('e36','m');
insert into EMPLOYEE2 values('e37','m');
insert into EMPLOYEE2 values('e38','m');
insert into EMPLOYEE2 values('e39','m');
insert into EMPLOYEE2 values('e40','m');
insert into EMPLOYEE2 values('e41','m');
insert into EMPLOYEE2 values('e42','m');
---------------------------------------------------------
create table DEPENDENT1(name varchar2(10),
age int,
relation varchar2(10),
eid varchar2(5),
primary key(name,eid));
insert into DEPENDENT1 values('daniel',
22,
'brother',
'e1');
insert into DEPENDENT1 values('chaitanya',
21,
'sisterinla',
'e2');
insert into DEPENDENT1 values('anees',
25,
'brother',
'e3');
insert into DEPENDENT1 values('bindya',
19,
'sister',
'e4');
insert into DEPENDENT1 values('dheeraj',
19,
'brother',
'e5');
insert into DEPENDENT1 values('prasad',
23,
'husband',
'e6');
insert into DEPENDENT1 values('naag',
25,
'husband',
'e7');
insert into DEPENDENT1 values('aparna',
29,
'sister',
'e8');
insert into DEPENDENT1 values('shivam',
49,
'father',
'e9');
insert into DEPENDENT1 values('sandy',
29,
'brother',
'e10');
insert into DEPENDENT1 values('ekka',
49,
'uncle',
'e11');
insert into DEPENDENT1 values('suchi',
21,
'sister',
'e12');
insert into DEPENDENT1 values('umesh',
21,
'brother',
'e13');
insert into DEPENDENT1 values('raj',
23,
'uncle',
'e14');
insert into DEPENDENT1 values('narayana',
22,
'brother',
'e15');
insert into DEPENDENT1 values('sidharth',
41,
'father',
'e16');
insert into DEPENDENT1 values('reema',
41,
'mother',
'e17');
insert into DEPENDENT1 values('nasaiah',
48,
'father',
'e18');
insert into DEPENDENT1 values('livingstan',
31,
'husband',
'e19');
insert into DEPENDENT1 values('gopal',
31,
'husband',
'e20');
insert into DEPENDENT1 values('moses',
30,
'brother',
'e21');
insert into DEPENDENT1 values('kullu',
30,
'brother',
'e22');
insert into DEPENDENT1 values('venu',
29,
'uncle',
'e23');
insert into DEPENDENT1 values('sneha',
21,
'wife',
'e24');
insert into DEPENDENT1 values('sita',
22,
'wife',
'e25');
insert into DEPENDENT1 values('gopika',
22,
'wife',
'e26');
insert into DEPENDENT1 values('ananya',
21,
'wife',
'e27');
insert into DEPENDENT1 values('anil',
25,
'husband',
'e28');
insert into DEPENDENT1 values('swathi',
21,
'wife',
'e29');
insert into DEPENDENT1 values('shreya',
22,
'wife',
'e30');
insert into DEPENDENT1 values('geneliya',
19,
'sister',
'e31');
insert into DEPENDENT1 values('rani',
21,
'sister',
'e32');
insert into DEPENDENT1 values('chandra',
19,
'brother',
'e33');
insert into DEPENDENT1 values('anupam',
22,
'uncle',
'e34');
insert into DEPENDENT1 values('vidya',
21,
'sister',
'e35');
insert into DEPENDENT1 values('akshya',
16,
'sister',
'e36');
insert into DEPENDENT1 values('stella',
16,
'sister',
'e37');
insert into DEPENDENT1 values('hepsibah',
19,
'wife',
'e38');
insert into DEPENDENT1 values('jessica',
16,
'sister',
'e39');
insert into DEPENDENT1 values('buelah',
21,
'wife',
'e40');
insert into DEPENDENT1 values('jashuva',
16,
'brother',
'e41');
insert into DEPENDENT1 values('ratnam',
16,
'brother',
'e42');
------------------------------------------------------------------
create table DEPENDENT2(name varchar2(10) primary key,
sex varchar2(5));
insert into DEPENDENT2 values('daniel','m');
insert into DEPENDENT2 values('chaitanya','f');
insert into DEPENDENT2 values('anees','m');
insert into DEPENDENT2 values('bindya','f');
insert into DEPENDENT2 values('dheeraj','m');
insert into DEPENDENT2 values('prasad','m');
insert into DEPENDENT2 values('naag','m');
insert into DEPENDENT2 values('aparna','f');
insert into DEPENDENT2 values('shivam','m');
insert into DEPENDENT2 values('sandy','m');
insert into DEPENDENT2 values('ekka','m');
insert into DEPENDENT2 values('suchi','f');
insert into DEPENDENT2 values('umesh','m');
insert into DEPENDENT2 values('raj','m');
insert into DEPENDENT2 values('narayana','m');
insert into DEPENDENT2 values('sidharth','m');
insert into DEPENDENT2 values('reema','f');
insert into DEPENDENT2 values('narsaiah','m');
insert into DEPENDENT2 values('livingstan','m');
insert into DEPENDENT2 values('gopal','m');
insert into DEPENDENT2 values('moses','m');
insert into DEPENDENT2 values('kullu','m');
insert into DEPENDENT2 values('venu','m');
insert into DEPENDENT2 values('sneha','f');
insert into DEPENDENT2 values('sita','f');
insert into DEPENDENT2 values('gopika','f');
insert into DEPENDENT2 values('ananya','f');
insert into DEPENDENT2 values('anil','m');
insert into DEPENDENT2 values('swathi','f');
insert into DEPENDENT2 values('shreya','f');
insert into DEPENDENT2 values('geneliya','f');
insert into DEPENDENT2 values('rani','f');
insert into DEPENDENT2 values('chandra','m');
insert into DEPENDENT2 values('anupam','m');
insert into DEPENDENT2 values('vidya','f');
insert into DEPENDENT2 values('akshya','f');
insert into DEPENDENT2 values('stella','f');
insert into DEPENDENT2 values('hepsibah','f');
insert into DEPENDENT2 values('jessica','f');
insert into DEPENDENT2 values('buelah','f');
insert into DEPENDENT2 values('jashuva','m');
insert into DEPENDENT2 values('ratnam','m');
----------------------------------------------------------------
create table ADS_ON(adtype varchar2(10),
adduram varchar2(10),
pcode varchar2(5),
aregno varchar2(5));
insert into ADS_ON values('tvad',
'2months',
'c3',
'a007');
insert into ADS_ON values('tvad',
'3months',
'l12',
'a007');
insert into ADS_ON values('paperad',
'11months',
's19',
'a007');
insert into ADS_ON values('internetad',
'1month',
'd4',
'a007');
insert into ADS_ON values('tvad',
'2months',
'p16',
'a007');
insert into ADS_ON values('tvad',
'1month',
'b2',
'a007');
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment