ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY';
ALTER SESSION SET NLS_LANGUAGE='ENGLISH';

REM  larg_emp.sql   (SW/05/1995)

drop table s_large_emp
/
create table s_large_emp
( id              number(7)      not null
, last_name       varchar2(25)   not null
, first_name      varchar2(25)
, userid          varchar2(8)
, 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)
, phone           varchar2(25)
, address         varchar2(255)
, city            varchar2(30)
, state           varchar2(20)
, country         varchar2(30)
, zip_code        varchar2(75)
, birth_date      date
, room_phone      varchar2(10)
, room_no         number(4)
)
/
INSERT INTO s_large_emp                                                         
 VALUES (1,'Velasquez','Carmen','cvelasqu','03-MAR-1990','','','President',50,2500
,'','1-206-104-0103','281 King Street','Seattle','Washington','USA','98101'
,'08-JAN-1955','','');                                                                 
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (2,'Ngao','LaDoris','lngao','08-MAR-1990','',1,'VP, Operations',41,1450
,'','','','','','','','','','');                                                   
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (3,'Nagayama','Midori','mnagayam','17-JUN-1991','',1,'VP, Sales',31,1400
,'','','','','','','','','','');                                                  
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (4,'Quick-To-See','Mark','mquickto','07-APR-1990','',1,'VP, Finance',10
,1450,'','','','','','','','','','');                                              
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (5,'Ropeburn','Audry','aropebur','04-MAR-1990','',1,'VP, Administration'
,50,1550,'','','','','','','','','','');                                          
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (6,'Urguhart','Molly','murguhar','18-JAN-1991','',2,'Warehouse Manager',41
,1200,'','','','','','','','','','');                                           
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (7,'Menchu','Roberta','rmenchu','14-MAY-1990','',2,'Warehouse Manager',42,
1250,'','','','','','','','','','');                                            
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (8,'Biri','Ben','bbiri','07-APR-1990','',2,'Warehouse Manager',43,1100
,'','','','','','','','','','');                                                    
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (9,'Catchpole','Antoinette','acatchpo','09-FEB-1992','',2
,'Warehouse Manager',44,1300,'','','','','','','','','','');                                     
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (10,'Havel','Marta','mhavel','27-FEB-1991','',2,'Warehouse Manager',45
,1307,'','','','','','','','','','');                                               
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (11,'Magee','Colin','cmagee','14-MAY-1990','',3,'Sales Representative',31,
1400,10,'','','','','','','','','');                                            
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (12,'Giljum','Henry','hgiljum','18-JAN-1992','',3,'Sales Representative'
,32,1490,12.5,'','','','','','','','','');                                        
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (13,'Sedeghi','Yasmin','ysedeghi','18-FEB-1991','',3
,'Sales Representative',33,1515,10,'','','','','','','','','');                                       
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (14,'Nguyen','Mai','mnguyen','22-JAN-1992','',3,'Sales Representative',34,
1525,15,'','','','','','','','','');                                            
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (15,'Dumas','Andre','adumas','09-OCT-1991','',3,'Sales Representative',35,
1450,17.5,'','','','','','','','','');                                          
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (16,'Maduro','Elena','emaduro','07-FEB-1992','',6,'Stock Clerk',41,1400
,'','','','','','','','','','');                                                   
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (17,'Smith','George','gsmith','08-MAR-1990','',6,'Stock Clerk',41,940
,'','','','','','','','','','');                                                     
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (18,'Nozaki','Akira','anozaki','09-FEB-1991','',7,'Stock Clerk',42,1200
,'','','','','','','','','','');                                                   
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (19,'Patel','Vikram','vpatel','06-AUG-1991','',7,'Stock Clerk',42,795
,'','','','','','','','','','');                                                     
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (20,'Newman','Chad','cnewman','21-JUL-1991','',8,'Stock Clerk',43,750
,'','','','','','','','','','');                                                     
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (21,'Markarian','Alexander','amarkari','26-MAY-1991','',8,'Stock Clerk',43
,850,'','','','','','','','','','');                                            
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (22,'Chang','Eddie','echang','30-NOV-1990','',9,'Stock Clerk',44,800
,'','','','','','','','','','');                                                      
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (23,'Patel','Radha','rpatel','17-OCT-1990','',9,'Stock Clerk',34,795
,'','','','','','','','','','');                                                      
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (24,'Dancs','Bela','bdancs','17-MAR-1991','',10,'Stock Clerk',45,860
,'','','','','','','','','','');                                                      
                                                                                
INSERT INTO s_large_emp                                                         
 VALUES (25,'Schwartz','Sylvie','sschwart','09-MAY-1991','',10,'Stock Clerk',45
,1100,'','','','','','','','','','');   

COMMIT;
ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD';
ALTER SESSION SET NLS_LANGUAGE='POLISH';                                           
