Exforsys.com
 

Sponsored Links

 

PL SQL Tutorials

 
Home Tech Articles PL SQL
 

Practice Oracle SQL*Plus Live - Part 1

 
Category: PL SQL
Comments (3)

This is an online SQL environment. It provides tutorials to learners, which they can interact with, execute their own SQL, and obtain automatic feedback on the quality of that SQL. Anyone is free to use the environment. Please follow these series of articles and practice them as mentioned to learn Oracle in easy steps. In the next Section we will be actually Practicing SQL step by step according to the learning process.



Tables and Structure used in this Practice. If you have Oracle installed on your local PC please download this script and run in the SQL prompt to create the sample tables we will be using here.


Download SQL Script


Download these tutorials which we will be using as part of our practice for reference.


1.1 Introduction (PDF)
1.2 SQL 1 (PDF)
1.3 SQL 2 (PDF)
1.4 SQL 3 (PDF)
2.1 Entity Relationship 1 (PDF)
2.2 Entity Relationship 2 (PDF)
2.3 Entity Relationship 3 (PDF)
2.4 Entity Relationship 4 (PDF)
3.1 Normalization (0NF-3NF) (PDF)
3.2 Normalization (BCNF-5NF) (PDF)
3.3 Relational Algebra Intro (PDF)
3.4 Relational Algebra Advanced (PDF)
4.1 Transactions (PDF)
4.2 Concurrency (PDF)
4.3 Storage Structures (PDF)
4.4 Recovery (PDF)
5.1 Embedded SQL (PDF)
5.2a Database Administrator Role (PDF)
5.2b Security (PDF)
5.3 Data Dictionary (PDF)

Mini 1 ER Tutorial 1-2 (PDF)
Mini 2ER Tutorial 3-5 (PDF)
Mini 3HOWTO for Multiple Choice (PDF)


Tables used in this :


TABLENAME TABLETYPE
course TABLE
department TABLE
empcourse TABLE
employee TABLE
jobhistory TABLE



Course:


COLNAME COLDESC
courseno integer primary key
cname varchar(30)
cdate date


Department:


COLNAME COLDESC
depno integer primary key
dname varchar(20)
location varchar(15)
head integer


empcourse


COLNAME COLDESC
empno integer references employee (empno)
courseno integer references course (courseno)
  primary key (empno, courseno)


employee


COLNAME COLDESC
empno integer primary key
surname varchar(15)
forenames varchar(30)
dob date
address varchar(50)
telno varchar(20)
depno integer references department (depno)


jobhistory


COLNAME COLDESC
empno integer references employee (empno)
position varchar(30)
startdate date
enddate date
salary decimal(8,2)
  primary key (empno, position)


Database Creation Scripts

Database NameCommentScript File
Jobs 2000Jobs tutorial databaseJobsv2000.sql
MusicianMusicians - create tablesmusician_tables.sql
MusicianMusicians - populate tablesmusician_gen.sql
DressmakerDressmaker - build and populatedressmaker.sql


Sample Code
  1. DROP TABLE empcourse;
  2. DROP TABLE jobhistory;
  3. DROP TABLE employee;
  4. DROP TABLE department;
  5. DROP TABLE course;
  6.  
  7. CREATE TABLE course(
  8.  courseno integer PRIMARY KEY,
  9.  cname varchar(30),
  10.  cdate date
  11. );
  12.  
  13. CREATE TABLE department(
  14.  depno integer PRIMARY KEY,
  15.  dname varchar(20),
  16.  location varchar(15),
  17.  head integer
  18. );
  19.  
  20. CREATE TABLE employee(
  21.  empno integer PRIMARY KEY,
  22.  surname varchar(15),
  23.  forenames varchar(30),
  24.  dob date,
  25.  address varchar(50),
  26.  telno varchar(20),
  27.  depno integer
  28. REFERENCES department (depno)
  29. );
  30.  
  31. CREATE TABLE jobhistory(empno integer REFERENCES employee (empno),
  32.    position varchar(30),
  33.    startdate date,
  34.    enddate date,
  35.    salary  decimal(8,2),
  36.    PRIMARY KEY (empno, position));
  37.  
  38. CREATE TABLE empcourse(empno integer REFERENCES employee (empno),
  39.   courseno integer REFERENCES course (courseno),
  40.   PRIMARY KEY (empno, courseno));
  41.  
  42. INSERT INTO course (courseno, cname, cdate) ( 1, 'Basic Accounting','11/JAN/1989');  
  43. INSERT INTO course (courseno, cname, cdate) VALUES ( 2, 'Further Accounting','25/JAN/1989');  
  44. INSERT INTO course (courseno, cname, cdate) VALUES ( 3,'Issues In Administration','27/SEP/1988');  
  45. INSERT INTO course (courseno, cname, cdate) VALUES ( 4,'More Administration','16/OCT/1988');  
  46. INSERT INTO course (courseno, cname, cdate) VALUES ( 5,'Ada','01/NOV/1988');  
  47. INSERT INTO course (courseno, cname, cdate) VALUES ( 6, 'Introduction To Ingres','05/FEB/1989');  
  48. INSERT INTO course (courseno, cname, cdate) VALUES ( 7, 'New Topologies','10/MAR/1989');  
  49. INSERT INTO course (courseno, cname, cdate) VALUES ( 8,'LANs','12/DEC/1988');  
  50. INSERT INTO course (courseno, cname, cdate) VALUES ( 9,'Structural Stress Analysis','20/FEB/1989');  
  51. INSERT INTO course (courseno, cname, cdate) VALUES ( 10,'Taffic Flow Analysis','24/OCT/1988');  
  52. INSERT INTO department (depno, dname, location, head)  VALUES (1,'accounts','floor 3',1);
  53. INSERT INTO department (depno, dname, location, head)  VALUES (2, 'administration', 'floor 2', 1);
  54. INSERT INTO department (depno, dname, location, head)  VALUES (3, 'software design', 'floor 1', 2);
  55. INSERT INTO department (depno, dname, location, head)  VALUES (4, 'communications', 'floor 4', 3);
  56. INSERT INTO department (depno, dname, location, head)  VALUES (5, 'engineering', 'floor 5', 7);
  57. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (1,'Jones','Elizabeth Barbara','05/JAN/1944', '26 Agnews Terrace, Shamrock Bay','212 337 2288',1);
  58. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (2,'Smith','Robert', '07/FEB/1947','18 Marsh Street, Tollcross, Edinburgh','031 732 8972', 1);
  59. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (3,'White','Allan','05/MAY/1961','6 Remote Place, North Berwick','121 555 6622', 1);
  60. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (4,'Reid','Gordon', '10/AUG/1963','9 Noble Road, Penicuik', '629 424 6713', 1);
  61. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (5,'MacCallan','Claire', '18/SEP/1958','25 Crisis Avenue, Leith, Edinburgh', '031 337 4166',1);
  62. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (6,'Murphy','Brian Charles', '30/JUN/1954','9 Roberts Street, Biggar', '331 229 4147', 1);
  63. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (7,'Gibson','James', '09/MAR/1948','11 Depressed Way, Glasgow', '041 447 8001', 2);
  64. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (8,'Andrews','John', '02/JAN/1958','73 Long Road, Lengthitown', '70 229 7213', 2);
  65. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (9,'Wright','Audrey Mary','02/JAN/1958','10 Nile Terrace, Polwarth, Edinburgh', '031 424 7092', 2);
  66. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (10,'Reagan','Anne', '17/AUG/1961','82 Longstone Road, Longstone, Edinburgh', '031 111 2799',2);
  67. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (11,'North','Annabel', '01/SEP/1962','35 Marchmont Terrace, Marchmont, Edinburgh', '031 447 2266', 2);
  68. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (12,'South','Todd James','28/FEB/1959','10 Shandon Road, Merchiston, Edinburgh', '031 333 1008', 2);
  69. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (13,'East','Ian','13/MAY/1942','47 Colinton Road, Craighlochart, Edinburgh', '031 424 5665', 2);
  70. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (14,'West','Jack', '15/JUN/1946','15 South West Gardens, Peebles','466 3176', 3);
  71. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (15,'Allen','Ester','27/FEB/1955', '10 Troon Street, Leith, Edinburgh', '031 424 2907', 3);
  72. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (16,'Brunell','Liza', '18/AUG/1962','8 Commercial Street, Tollcross, Edinburgh','031 424 1656', 3);
  73. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (17,'Robertson','David Andrew', '07/AUG/1960','9 North Loan,South Queensferry', '031 447 8213', 3);
  74. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (18,'Robinson','Allan','09/JUN/1961','31 Newall Terrace, Hawick','229 0854', 3);
  75. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (19,'Roberts','Robert', '01/JAN/1959', '7 Peebles Road,Melrose','402 9213', 3);
  76. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (20,'Murray','James', '06/MAR/1964','40 Blackhall Loan,Biggar','121 444 4580', 3);
  77. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (21,'Bryce','Anne', '13/SEP/1965', '22 Forresthill Place, Greyfriars, Edinburgh','031 402 6666', 3);
  78. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (22,'Cowan','Audrey', '03/APR/1940','12 Down Street, Brayend', '228 9321', 4);
  79. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (23,'Stevenson','John David', '12/DEC/1954','16 Rubber Road,Stampingham', '337 6262', 4);
  80. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (24,'Dickson','William', '06/JAN/1950','11 Newplace Road, Newton', '041 444 6730', 4);
  81. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (25,'Brownlie','Matthew',   '14/MAY/1954','80 Cowan Road, Shandon, Edinburgh', '031 228 4141', 4);
  82. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (26,'Gordon','Mark','12/FEB/1960','10 Whyte Place, North Berwick','424 1024', 4);
  83. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (27,'Kennedy','Luke','26/JUL/1952','14 Bucket Street, Musselburgh','031 414 7312', 5);
  84. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (28,'Grant','Lynn','12/JUL/1956','3 Dey Terrace, Selkirk', '337 8911', 5);
  85. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (29,'MacDonald','Elizabeth', '03/SEP/1968','23 Neidpath Road, Peebles', '444 8998',5);
  86. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (30,'MacDugle','Shirley', '09/OCT/1964','8 Rosebank Terrace, Shandon, Edinburgh', '031 447 1189', 5);
  87. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (31,'Douglas','Chris', '23/JUN/1955','19 High Street, Livingston', '031 229 6792', 5);
  88. INSERT INTO employee (empno, surname, forenames, dob, address, telno, depno) VALUES (32,'Christie','Malcolm',   '25/JUL/1959','11 Rounders Park, Polwarth, Edinburgh','031 424 8406', 5);
  89. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (1, 'Accounts Manager', '12/JAN/1976', NULL, 30000.00);
  90. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (1, 'Assistant Accounts Manager',   '11/FEB/1972', '12/JAN/1976',22000.00);
  91. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (1, 'Accountant',   '10/MAR/1968','11/FEB/1972',  15000.00);
  92. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (1, 'Junior Accountant','09/APR/1964','10/MAR/1968', 6000.00);
  93. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (2, 'Assistant Accounts Manager',   '08/MAY/1976', NULL, 25000.00);
  94. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (2, 'Accountant',   '07/JUN/1971', '08/MAY/1976', 16000.00);
  95. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (2,  'Junior Accountant', '06/JUL/1967', '07/JUN/1971', 8000.00);
  96. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (3, 'Accountant', '05/AUG/1984', NULL, 16000.00);
  97. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (3, 'Junior Accountant', '04/SEP/1981','05/AUG/1984', 8000.00);
  98. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (4, 'Accountant', '05/OCT/1989', NULL, 16000.00);
  99. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (5,'Accountant','02/NOV/1980',NULL, 16000.00);
  100. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (5, 'Junior Accountant','01/DEC/1978','02/NOV/1980', 8000.00);
  101. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (6, 'Accountant', '12/JAN/1980', NULL, 16000.00);
  102. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (6, 'Junior Accountant', '11/FEB/1974', '12/JAN/1980', 8000.00);
  103. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (7, 'Admin Manager', '10/MAR/1980',NULL, 30000.00);
  104. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (7, 'Assistant Admin Manager', '09/APR/1974', '10/MAR/1980',22000.00);
  105. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (7, 'Senior Admin Assistant', '01/DEC/1968', '09/APR/1974',16000.00);
  106. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (7, 'Admin Assistant', '07/MAY/1960', '01/DEC/1968', 10000.00);
  107. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (8, 'Assistant Admin Manager', '10/MAR/1980', NULL, 20000.00);
  108. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (8, 'Senior Admin Assistant', '09/APR/1977', '10/MAR/1980',12000.00);
  109. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (8, 'Admin Assistant', '01/DEC/1976', '09/APR/1977', 8000.00);
  110. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (9, 'Senior Admin Assistant', '10/JUL/1988', NULL, 14000.00);
  111. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (9, 'Admin Assistant', '08/JUN/1982', '10/JUL/1988',  10000.00);
  112. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (10,'Admin Assistant', '06/SEP/1986', NULL, 12000.00);
  113. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (10,'Junior Admin Assistant', '22/SEP/1983','06/SEP/1986',6000.00);
  114. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (11,'Admin Assistant', '13/MAR/1982', NULL, 15000.00);
  115. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (11,'Junior Admin Assistant', '23/OCT/1980', '13/MAR/1982',8000.00);
  116. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (12,'Admin Assistant','26/FEB/1982', NULL, 15000.00);
  117. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (12,'Junior Admin Assistant', '03/JAN/1977', '26/FEB/1982', 6500.00);
  118. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (13,'Admin Assistant', '17/APR/1988', NULL, 16000.00);
  119. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (14,'Admin Assistant', '14/NOV/1985', NULL, 16000.00);
  120. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (15,'Senior Systems Analyst', '21/AUG/1988', NULL, 35000.00);
  121. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (15,'Systems Analyst', '09/FEB/1986','21/AUG/1988', 31000.00);
  122. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (15,'Analyst Programmer', '17/JAN/1984', '09/FEB/1986', 25000.00);
  123. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (15, 'Programmer', '13/MAY/1980', '17/JAN/1984', 16000.00);
  124. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (16,'Systems Analyst', '25/APR/1991', NULL, 30000.00);
  125. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (16,'Analyst Programmer',   '16/NOV/1986', '25/APR/1991',21000.00);
  126. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (16,'Programmer',   '01/OCT/1984', '16/NOV/1986', 16000.00);
  127. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (17,'Analyst Programmer',   '17/JAN/1988', NULL,  21000.00);
  128. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (17,'Programmer', '01/OCT/1984','17/JAN/1988', 16000.00);
  129. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (18,'Analyst Programmer',   '23/SEP/1988', NULL,  22000.00);
  130. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (18,'Programmer',   '01/OCT/1984','23/SEP/1988', 16000.00);
  131. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (19,'Analyst Programmer',   '23/SEP/1988', NULL, 22000.00);
  132. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (19,'Programmer',   '01/OCT/1984','23/SEP/1988'  , 16000.00);
  133. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (20,'Analyst Programmer',   '23/SEP/1988', NULL,  22000.00);
  134. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (20,'Programmer',   '01/OCT/1984' ,'23/SEP/1988' , 16000.00);
  135. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (21,'Analyst Programmer',   '13/DEC/1991', NULL, 25000.00);
  136. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (21,'Programmer',   '11/SEP/1989','13/DEC/1991', 21000.00);
  137. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (22,'Communications Manager', '03/AUG/1985', NULL, 36000.00);
  138. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (22,'Senior Communications Engineer', '21/JUN/1977','03/AUG/1985', 26000.00);
  139. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (22,'Communications Engineer', '13/MAY/1975', '21/JUN/1977', 12000.00);
  140. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (22,'Electrical Engineer', '08/FEB/1966', '13/MAY/1975' ,8000.00);
  141. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (23,'Senior Communications Engineer', '03/AUG/1985', NULL, 18000.00);
  142. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (23,'Communications Engineer','21/JUN/1979', '03/AUG/1985',9000.00);
  143. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (23,'Software Engineer', '14/FEB/1977', '21/JUN/1979', 5000.00);
  144. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (24,'Communications Engineer','08/OCT/1985', NULL, 15000.00);
  145. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (24,'Electrical Engineer', '06/MAY/1980', '08/OCT/1985',13000.00);
  146. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (25,'Communications Engineer', '01/OCT/1988', NULL, 19000.00);
  147. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (25,'Software Engineer', '25/AUG/1985','01/OCT/1988', 16000.00);
  148. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (25,'Systems Programmer','29/JAN/1983', '25/AUG/1985', 11000.00);
  149. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (25,'Programmer',   '14/SEP/1980', '29/JAN/1983', 9000.00);
  150. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (26,'Communications Engineer', '13/MAR/1988', NULL, 19500.00);
  151. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (26,'Software Engineer', '30/AUG/1985','13/MAR/1988', 17000.00);
  152. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (26,'Trainee Engineer', '13/SEP/1982','30/AUG/1985', 11000.00);
  153. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (26,'Electronic Engineer', '01/SEP/1980','13/SEP/1982', 9000.00);
  154. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (27,'Senior Chief Engineer', '01/NOV/1990', NULL, 25000.00);
  155. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (27,'Chief Engineer', '20/JUN/1986','01/NOV/1990', 17000.00);
  156. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (27,'Mechanical Engineer', '19/APR/1981' ,'20/JUN/1986',11000.00);
  157. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (27,'Graduate Engineer', '13/SEP/1975','19/APR/1981', 6000.00);
  158. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (28,'Chief Engineer', '06/JUL/1989', NULL, 29000.00);
  159. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (28,'Civil Engineer', '17/APR/1984', '06/JUL/1989', 17000.00);
  160. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (28,'Trainee Engineer', '10/DEC/1978','17/APR/1984', 12000.00);
  161. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (28,'Graduate Engineer','01/SEP/1978','10/DEC/1978', 3000.00);
  162. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (29,'Electrical Engineer', '09/FEB/1986', NULL, 17000.00);
  163. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (29,'Graduate Engineer',    '03/OCT/1980','09/FEB/1986', 14000.00);
  164. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (30,'Senior Electrical Engineer',   '30/APR/1992', NULL,  22000.00);
  165. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (30,'Electrical Engineer', '06/MAR/1987','30/APR/1992', 17000.00);
  166. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (31,'Senior Mechanical Engineer',   '30/MAY/1987',NULL, 22000.00);
  167. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (31,'Mechanical Engineer', '06/JUN/1980', '30/MAY/1987',17000.00);
  168. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (32,'Systems Engineer', '01/MAR/1991', NULL, 19000.00);
  169. INSERT INTO jobhistory (empno, position, startdate, enddate, salary) VALUES (32,'Electronics Engineer', '31/OCT/1989','01/MAR/1991', 18000.00);
Copyright exforsys.com



Sample Code
  1. INSERT INTO empcourse(empno, courseno) VALUES (1, 1);
  2. INSERT INTO empcourse(empno, courseno) VALUES (1, 2);
  3. INSERT INTO empcourse(empno, courseno) VALUES (2, 1);
  4. INSERT INTO empcourse(empno, courseno) VALUES (2, 2);
  5. INSERT INTO empcourse(empno, courseno) VALUES (7, 3);
  6. INSERT INTO empcourse(empno, courseno) VALUES (7, 4);
  7. INSERT INTO empcourse(empno, courseno) VALUES (8, 3);
  8. INSERT INTO empcourse(empno, courseno) VALUES (8, 4);
  9. INSERT INTO empcourse(empno, courseno) VALUES (14, 5);
  10. INSERT INTO empcourse(empno, courseno) VALUES (14, 6);
  11. INSERT INTO empcourse(empno, courseno) VALUES (15, 5);
  12. INSERT INTO empcourse(empno, courseno) VALUES (15, 6);
  13. INSERT INTO empcourse(empno, courseno) VALUES (21, 7);
  14. INSERT INTO empcourse(empno, courseno) VALUES (22, 7);
  15. INSERT INTO empcourse(empno, courseno) VALUES (22, 8);
  16. INSERT INTO empcourse(empno, courseno) VALUES (19, 5);
  17. INSERT INTO empcourse(empno, courseno) VALUES (19, 6);
Copyright exforsys.com



Read Next: Practice Oracle SQL*Plus Live - Part 2



 

 

Comments


krishnaprakash N said:

  Very well organized PDF file
August 9, 2007, 8:16 am

sandeep roy said:

  I really have discovered many unfacts inside the DBMS through this tutorial.thanks for such a representation which enables students to get crealyidea abbout the topic.
It wondered me so much that i have to take this notes to my students.Thanks a lot for your efforts......roy
October 23, 2007, 2:57 pm

amit dhar said:

  I really have discovered many unfacts inside the DBMS through this tutorial.thanks for such a representation which enables students to get crealyidea abbout the topic.
It wondered me so much that i have to take this notes to my students.Thanks a lot for your efforts......roy
October 22, 2008, 10:19 am

Post Your Comment:

Members Please Login
Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe    

Sponsored Links

 

Subscribe via RSS


Get Daily Updates via Subscribe to Exforsys Free Training via email


Get Latest Free Training Updates delivered directly to your Inbox...

Enter your email address:


 

Subscribe to Exforsys Free Training via RSS
 

 
Partners -  Privacy and Legal Policy -  Site News -  Contact   Sitemap  

Copyright © 2000 - 2009 exforsys.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape