s_emp.sql

SQL 语言二次开发实际经典开发实例希望对初学者有帮助

DROP TABLE S_EMP;
/
CREATE TABLE S_EMP (
 ID             NUMBER(7) 	NOT NULL,
 LAST_NAME	VARCHAR2(25)	NOT NULL,
 FIRST_NAME	VARCHAR2(25),
 USERID		VARCHAR2(8)	NOT NULL,
 START_DATE	DATE,
 COMMENTS	VARCHAR2(255),
 MANAGER_ID	NUMBER(7),
 TITLE		VARCHAR2(25),
 DEPT_ID	NUMBER(7),
 SALARY		NUMBER(11,2),
 COMMISSION_PCT	NUMBER(4,2)
 );
/

INSERT INTO S_EMP VALUES (1,'Velasquez','Carmen','cvelasqu','03-MAR-90','',NULL,'President',50,2500,NULL);
INSERT INTO S_EMP VALUES (2,'Ngao','LaDoris','lngao','08-MAR-90','',1,'VP, Operations',41,1450,NULL);
INSERT INTO S_EMP VALUES (3,'Nagayama','Nidori','mnagayam','17-JUN-91','',1,'VP, Sales',31,1400,NULL);
INSERT INTO S_EMP VALUES (4,'Quick_To_See','Mark','mquickto','07-APR-90','',1,'VP, Fianace',10,1450,NULL);
INSERT INTO S_EMP VALUES (5,'Ropeburn','Audry','aropebur','04-MAR-90','',1,'VP, Administration',50,1550,NULL);
INSERT INTO S_EMP VALUES (6,'Urguhart','Molly','murguhar','18-JAN-91','',2,'Warehouse Manager',41,1200,NULL);
INSERT INTO S_EMP VALUES (7,'Menchu','Roberta','rmenchu','14-MAY-90','',2,'Warehouse Manager',42,1250,NULL);
INSERT INTO S_EMP VALUES (8,'Biri','Ben','bbiri','07-APR-90','',2,'Warehouse Manager',43,1100,NULL);
INSERT INTO S_EMP VALUES (9,'Catchpole','Antoinette','acatchpo','09-FEB-92','',2,'Warehouse Manager',44,1300,NULL);
INSERT INTO S_EMP VALUES (10,'Havel','Marta','mhavel','27-FEB-92','',2,'Warehouse Manager',45,1307,NULL);
INSERT INTO S_EMP VALUES (11,'Magee','Colin','cmagee','14-MAY-90','',3,'Sales Representative',31,1400,10);
INSERT INTO S_EMP VALUES (12,'Giljum','Henry','hgiljum','18-JAN-92','',3,'Sales Representative',32,1490,12.5);
INSERT INTO S_EMP VALUES (13,'Sedeghi','Yasmin','ysedeghi','18-FEB-91','',3,'Sales Representative',33,1515,10);
INSERT INTO S_EMP VALUES (14,'Nguyen','Mai','mnguyen','22-JAN-92','',3,'Sales Representative',34,1525,15);
INSERT INTO S_EMP VALUES (15,'Dumas','Andre','adumas','09-OCT-91','',3,'Sales Representative',35,1450,17.5);
INSERT INTO S_EMP VALUES (16,'Maduro','Elena','emaduro','07-FEB-92','',6,'Stock Clerk',41,1400,NULL);
INSERT INTO S_EMP VALUES (17,'Smith','George','gsmith','08-MAR-90','',6,'Stock Clerk',41,940,NULL);
INSERT INTO S_EMP VALUES (18,'Nozaki','Akira','anozaki','09-FEB-91','',7,'Stock Clerk',42,1200,NULL);
INSERT INTO S_EMP VALUES (19,'Patel','Vikram','vpatel','06-AUG-91','',7,'Stock Clerk',42,795,NULL);
INSERT INTO S_EMP VALUES (20,'Newman','Chad','cnewman','21-JUL-91','',8,'Stock Clerk',43,750,NULL);
INSERT INTO S_EMP VALUES (21,'Markarian','Alexander','amarkari','26-MAY-91','',8,'Stock Clerk',43,850,NULL);
INSERT INTO S_EMP VALUES (22,'Chang','Eddie','echang','30-NOV-90','',9,'Stock Clerk',44,800,NULL);
INSERT INTO S_EMP VALUES (23,'Patel','Radha','rpatel','17-OCT-90','',9,'Stock Clerk',34,795,NULL);
INSERT INTO S_EMP VALUES (24,'Dancs','Bela','bdancs','17-MAR-91','',10,'Stock Clerk',45,860,NULL);
INSERT INTO S_EMP VALUES (25,'Schwartz','Sylvie','sschwart','09-MAY-91','',10,'Stock Clerk',45,1100,NULL);