Re: pl/sql: display employees who hired in specific month
Date: Thu, 10 Apr 2008 06:27:11 -0700 (PDT)
Message-ID: <ecd1177d-9e93-42c0-94b0-fb04a10b8c85@f63g2000hsf.googlegroups.com>
On Apr 9, 5:32 pm, chris <lazyboy..._at_yahoo.com> wrote:
> On Apr 9, 11:50 am, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
>
>
>
>
>
> > Comments embedded.
> > On Apr 9, 12:42 pm, chris <lazyboy..._at_yahoo.com> wrote:
>
> > > Hi All,
>
> > > I'm trying to write a simple script which displays all employees who
> > > are hired in Sept in 1 output & the others are in a different output.
> > > So far, when I run my script, all employees (including emp who are
> > > hired in the month of Sept) are displayed in 'other employees'
> > > section. It looks like the 1st part of the IF condition doesn't
> > > work.
>
> > Of course it works, it simply doesn't work as you expect.
>
> > > Any helps/suggestions are appreciated.
>
> > > DECLARE
> > > CURSOR emp_cursor IS SELECT employee_id, last_name,
> > > TO_CHAR(hire_date, 'month') "hire_date"
> > > FROM employees;
> > > hiredate VARCHAR2(30);
> > > empno employees.employee_id%TYPE;
> > > lname employees.last_name%TYPE;
> > > my_month VARCHAR2(30) := 'september';
>
> > > BEGIN
> > > OPEN emp_cursor;
> > > LOOP
> > > FETCH emp_cursor INTO empno, lname, hiredate;
> > > IF hiredate = UPPER(my_month) THEN
> > > DBMS_OUTPUT.PUT_LINE ('Sep employees: ' || empno || lname
> > > || hiredate);
> > > ELSE
> > > DBMS_OUTPUT.PUT_LINE ('other employees: ' || empno ||
> > > lname || hiredate);
> > > END IF;
> > > EXIT WHEN emp_cursor%NOTFOUND;
> > > END LOOP;
> > > CLOSE emp_cursor;
> > > END;
> > > /
>
> > > TIA,
> > > -Chris
>
> > Let's take your example, rewrite it slightly to use the EMP table
> > instead and see why you can't get what you want:
>
> > SQL> set serveroutput on size 1000000
> > SQL> --
> > SQL> -- Your code, using EMP table
> > SQL> --
> > SQL> DECLARE
> > 2 CURSOR emp_cursor IS
> > 3 SELECT empno, ename,
> > 4 TO_CHAR(hiredate, 'month') hire_date -- returns lower-case
> > month
> > 5 FROM emp;
> > 6
> > 7 hiredate VARCHAR2(30);
> > 8 empno emp.empno%TYPE;
> > 9 lname emp.ename%TYPE;
> > 10 my_month VARCHAR2(30) := 'september';
> > 11
> > 12
> > 13 BEGIN
> > 14 OPEN emp_cursor;
> > 15 LOOP
> > 16 FETCH emp_cursor INTO empno, lname, hiredate;
> > 17 -- comparing lower case to upper case will never match
> > 18 IF hiredate = UPPER(my_month) THEN
> > 19 DBMS_OUTPUT.PUT_LINE ('Sep employees: ' || empno || lname ||
> > hiredate);
> > 20 ELSE
> > 21 DBMS_OUTPUT.PUT_LINE ('other employees: ' || empno || lname ||
> > hiredate);
> > 22 END IF;
> > 23 EXIT WHEN emp_cursor%NOTFOUND;
> > 24 END LOOP;
> > 25 CLOSE emp_cursor;
> > 26 END;
> > 27 /
> > other employees: 7369SMITHdecember
> > other employees: 7499ALLENfebruary
> > other employees: 7521WARDfebruary
> > other employees: 7566JONESapril
> > other employees: 7654MARTINseptember
> > other employees: 7698BLAKEmay
> > other employees: 7782CLARKjune
> > other employees: 7788SCOTTdecember
> > other employees: 7839KINGnovember
> > other employees: 7844TURNERseptember
> > other employees: 7876ADAMSjanuary
> > other employees: 7900JAMESdecember
> > other employees: 7902FORDdecember
> > other employees: 7934MILLERjanuary
> > other employees: 7934MILLERjanuary
>
> > PL/SQL procedure successfully completed.
>
> > SQL>
> > SQL>
> > SQL> --
> > SQL> -- Working code, providing the proper results
> > SQL> --
> > SQL> DECLARE
> > 2 CURSOR emp_cursor IS
> > 3 SELECT empno, ename,
> > 4 TO_CHAR(hiredate, 'month') hire_date -- returns lower-case
> > month
> > 5 FROM emp;
> > 6
> > 7 my_month VARCHAR2(30) := 'september';
> > 8
> > 9
> > 10 BEGIN
> > 11 FOR emprec in emp_cursor LOOP
> > 12 -- comparing like case
> > 13 IF emprec.hire_date = my_month THEN
> > 14 DBMS_OUTPUT.PUT_LINE ('Sep employees: ' || emprec.empno ||'
> > '|| emprec.ename ||' '|| emprec.hire_date);
> > 15 ELSE
> > 16 DBMS_OUTPUT.PUT_LINE ('other employees: ' || emprec.empno
> > ||' '||emprec.ename ||' '|| emprec.hire_date);
> > 17 END IF;
> > 18 END LOOP;
> > 19 END;
> > 20 /
> > other employees: 7369 SMITH december
> > other employees: 7499 ALLEN february
> > other employees: 7521 WARD february
> > other employees: 7566 JONES april
> > Sep employees: 7654 MARTIN september
> > other employees: 7698 BLAKE may
> > other employees: 7782 CLARK june
> > other employees: 7788 SCOTT december
> > other employees: 7839 KING november
> > Sep employees: 7844 TURNER september
> > other employees: 7876 ADAMS january
> > other employees: 7900 JAMES december
> > other employees: 7902 FORD december
> > other employees: 7934 MILLER january
>
> > PL/SQL procedure successfully completed.
>
> > SQL>
>
> > Attention to detail is important.
>
> > David Fitzjarrell
>
> Thanks a lot for all of your helps David & All. Actually, I just use
> dbms_output pkgs to verify the if condition & I understand where
> Sybrand is coming from & I'm all appreciating for that. Below is my
> actual codes & it still has errors errors when I'm running. Do you
> happen to know where is the errors coming from? THX ALOTS!!!
>
> CREATE OR REPLACE PROCEDURE raise_sal
> ( empno IN employees.employee_id%TYPE,
> percent IN NUMBER)
> IS
> BEGIN
> UPDATE employees
> SET salary = salary * (1 + percent/100)
> WHERE employee_id = empno;
> COMMIT;
> END raise_sal;
> /
>
> -----
>
> SET SERVEROUTPUT ON
> SET VERIFY OFF
>
> DROP TABLE emp_raise;
> CREATE TABLE emp_raise AS (SELECT * FROM employees WHERE 1 = 2);
> DROP TABLE emp_no_raise;
> CREATE TABLE emp_no_raise AS (SELECT * FROM employees WHERE 1 = 2);
>
> DECLARE
>
> CURSOR emp_cursor IS
> SELECT employee_id empno, first_name fname, last_name
> lname, email email_addr,
> phone_number phoneno, TO_CHAR(hire_date, 'month')
> hire_date, job_id jobid, salary sal,
> commission_pct comm, manager_id mgr_id,
> department_id deptno
> FROM employees;
>
> my_month VARCHAR2(30) := 'september';
>
> BEGIN
> FOR emp_rec IN emp_cursor LOOP
> IF emp_rec.hire_date = my_month THEN
> raise_sal(empno => emp_rec.empno, percent => 30);
> INSERT INTO emp_raise (employee_id, first_name,
> last_name, email, phone_number,
> hire_date,
> job_id, salary, commission_pct, manager_id,
>
> department_id)
> VALUES (emp_rec.empno, emp_rec.fname,
> emp_rec.lname, emp_rec.email_addr,
> emp_rec.phoneno,
> emp_rec.hire_date, emp_rec.jobid, emp_rec.sal,
> emp_rec.comm,
> emp_rec.mgr_id, emp_rec.deptno);
> ELSE
> INSERT INTO emp_no_raise (employee_id, first_name,
> last_name, email, phone_number,
> hire_date,
> job_id, salary, commission_pct, manager_id,
>
> department_id)
> VALUES (emp_rec.empno, emp_rec.fname,
> emp_rec.lname, emp_rec.email_addr,
> emp_rec.phoneno,
> emp_rec.hire_date, emp_rec.jobid, emp_rec.sal,
> emp_rec.comm,
> emp_rec.mgr_id, emp_rec.deptno);
> END IF;
> END LOOP;
> END;
> /
> SELECT * FROM emp_raise;
> SELECT * FROM emp_no_raise;
>
> DECLARE
> *
>
> ERROR at line 1:
> ORA-01858: a non-numeric character was found where a numeric was
> expected
> ORA-06512: at line 22- Hide quoted text -
>
> - Show quoted text -
The error is produced by the hire_date value; you're trying to insert a varchar2 string into a date column and it won't work:
SQL> -- SQL> -- Create the RAISE_SAL procedure SQL> -- SQL> SQL> CREATE OR REPLACE PROCEDURE raise_sal 2 ( empno IN employees.employee_id%TYPE, 3 percent IN NUMBER)
4 IS
5 BEGIN
6 UPDATE employees 7 SET salary = salary * (1 + percent/100) 8 WHERE employee_id = empno; 9 COMMIT;
10 END raise_sal;
11 /
Procedure created.
SQL> SQL> SET SERVEROUTPUT ON SQL> SET VERIFY OFF SQL> SQL> -- SQL> -- Prepare the destination tables for input SQL> -- SQL> SQL> DROP TABLE emp_raise;
Table dropped.
SQL> CREATE TABLE emp_raise AS (SELECT * FROM employees WHERE 1 = 2);
Table created.
SQL> DROP TABLE emp_no_raise;
Table dropped.
SQL> CREATE TABLE emp_no_raise AS (SELECT * FROM employees WHERE 1 = 2);
Table created.
SQL> SQL> -- SQL> -- This code won't work because a date isn't SQL> -- supplied for the inserted value SQL> -- SQL> SQL> DECLARE 2 3 CURSOR emp_cursor IS 4 SELECT employee_id empno, first_name fname, last_name lname, email email_addr, 5 phone_number phoneno, TO_CHAR(hire_date, 'month') hire_date, job_id jobid, salary sal, 6 commission_pct comm, manager_id mgr_id, department_id deptno 7 FROM employees; 8 9 my_month VARCHAR2(30) := 'september';10
11 BEGIN
12 FOR emp_rec IN emp_cursor LOOP 13 IF emp_rec.hire_date = my_month THEN 14 raise_sal(empno => emp_rec.empno, percent => 30); 15 INSERT INTO emp_raise (employee_id, first_name, last_name, email, phone_number, 16 hire_date, job_id, salary, commission_pct, manager_id, department_id) 17 VALUES (emp_rec.empno, emp_rec.fname,emp_rec.lname, emp_rec.email_addr, 18 emp_rec.phoneno, emp_rec.hire_date, emp_rec.jobid, emp_rec.sal, 19 emp_rec.comm, emp_rec.mgr_id, emp_rec.deptno); 20 ELSE 21 INSERT INTO emp_no_raise (employee_id, first_name, last_name, email, phone_number, 22 hire_date, job_id, salary, commission_pct, manager_id, department_id) 23 VALUES (emp_rec.empno, emp_rec.fname, emp_rec.lname, emp_rec.email_addr, 24 emp_rec.phoneno, emp_rec.hire_date, emp_rec.jobid, emp_rec.sal, 25 emp_rec.comm, emp_rec.mgr_id, emp_rec.deptno); 26 END IF; 27 END LOOP;
28 END;
29 /
DECLARE
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected
ORA-06512: at line 21
SQL> SQL> -- SQL> -- Well, we have no records because the inserts failed SQL> -- SQL> SQL> select * from emp_raise;
no rows selected
SQL> select * From emp_no_raise;
no rows selected
All you've selected is the character value for the month name, nothing more. If we change the code to include the full hire_date value as hiredt and modify the insert statements to use that value, lo and behold, things work:
SQL> SQL> -- SQL> -- Let's try again SQL> -- SQL> -- This code works because we do select SQL> -- an actual date field to use for the insert SQL> -- SQL> SQL> DECLARE 2 3 CURSOR emp_cursor IS 4 SELECT employee_id empno, first_name fname, last_name lname, email email_addr, 5 phone_number phoneno, TO_CHAR(hire_date, 'month') hire_date, job_id jobid, salary sal, 6 commission_pct comm, manager_id mgr_id, department_id deptno, hire_date hiredt 7 FROM employees; 8 9 my_month VARCHAR2(30) := 'september';10
11 BEGIN
12 FOR emp_rec IN emp_cursor LOOP 13 IF emp_rec.hire_date = my_month THEN 14 raise_sal(empno => emp_rec.empno, percent => 30); 15 INSERT INTO emp_raise (employee_id, first_name, last_name, email, phone_number, 16 hire_date, job_id, salary, commission_pct, manager_id, department_id) 17 VALUES (emp_rec.empno, emp_rec.fname,emp_rec.lname, emp_rec.email_addr, 18 emp_rec.phoneno, emp_rec.hiredt, emp_rec.jobid, emp_rec.sal, 19 emp_rec.comm, emp_rec.mgr_id, emp_rec.deptno); 20 ELSE 21 INSERT INTO emp_no_raise (employee_id, first_name, last_name, email, phone_number, 22 hire_date, job_id, salary, commission_pct, manager_id, department_id) 23 VALUES (emp_rec.empno, emp_rec.fname, emp_rec.lname, emp_rec.email_addr, 24 emp_rec.phoneno, emp_rec.hiredt, emp_rec.jobid, emp_rec.sal, 25 emp_rec.comm, emp_rec.mgr_id, emp_rec.deptno); 26 END IF; 27 END LOOP;
28 END;
29 /
PL/SQL procedure successfully completed.
SQL>
SQL> --
SQL> -- Now we get data
SQL> --
SQL>
SQL> select * from emp_raise;
EMPLOYEE_ID FIRST_NAME LAST_NAME
EMAIL PHONE_NUMBER HIRE_DATE
JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- -------------------------
------------------------- -------------------- --------- ----------
---------- -------------- ---------- -------------
200 Jennifer Whalen
JWHALEN 515.123.4444 17-SEP-87
AD_ASST 5720 101 10
101 Neena Kochhar
NKOCHHAR 515.123.4568 21-SEP-89
AD_VP 22100 100 90
110 John Chen
JCHEN 515.124.4269 28-SEP-97
FI_ACCOUNT 10660 108 100
111 Ismael Sciarra
ISCIARRA 515.124.4369 30-SEP-97
FI_ACCOUNT 10010 108 100
126 Irene Mikkilineni
IMIKKILI 650.124.1224 28-SEP-98
ST_CLERK 3510 120 50
SQL> select * From emp_no_raise;
EMPLOYEE_ID FIRST_NAME LAST_NAME
EMAIL PHONE_NUMBER HIRE_DATE
JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- -------------------------
------------------------- -------------------- --------- ----------
---------- -------------- ---------- -------------
195 Vance Jones
VJONES 650.501.4876 17-MAR-99
SH_CLERK 2800 123 50
196 Alana Walsh
AWALSH 650.507.9811 24-APR-98
SH_CLERK 3100 124 50
197 Kevin Feeney
KFEENEY 650.507.9822 23-MAY-98
SH_CLERK 3000 124 50
198 Donald OConnell
DOCONNEL 650.507.9833 21-JUN-99
SH_CLERK 2600 124 50
199 Douglas Grant
DGRANT 650.507.9844 13-JAN-00
SH_CLERK 2600 124 50
201 Michael Hartstein
MHARTSTE 515.123.5555 17-FEB-96
MK_MAN 13000 100 20
202 Pat Fay
PFAY 603.123.6666 17-AUG-97
MK_REP 6000 201 20
203 Susan Mavris
SMAVRIS 515.123.7777 07-JUN-94
HR_REP 6500 101 40
204 Hermann Baer
HBAER 515.123.8888 07-JUN-94
PR_REP 10000 101 70
205 Shelley Higgins
SHIGGINS 515.123.8080 07-JUN-94
AC_MGR 12000 101 110
206 William Gietz
WGIETZ 515.123.8181 07-JUN-94
AC_ACCOUNT 8300 205 110
EMPLOYEE_ID FIRST_NAME LAST_NAME
EMAIL PHONE_NUMBER HIRE_DATE
JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- -------------------------
------------------------- -------------------- --------- ----------
---------- -------------- ---------- -------------
100 Steven King
SKING 515.123.4567 17-JUN-87
AD_PRES 24000 90
102 Lex De Haan
LDEHAAN 515.123.4569 13-JAN-93
AD_VP 17000 100 90
103 Alexander Hunold
AHUNOLD 590.423.4567 03-JAN-90
IT_PROG 9000 102 60
104 Bruce Ernst
BERNST 590.423.4568 21-MAY-91
IT_PROG 6000 103 60
105 David Austin
DAUSTIN 590.423.4569 25-JUN-97
IT_PROG 4800 103 60
106 Valli Pataballa
VPATABAL 590.423.4560 05-FEB-98
IT_PROG 4800 103 60
107 Diana Lorentz
DLORENTZ 590.423.5567 07-FEB-99
IT_PROG 4200 103 60
108 Nancy Greenberg
NGREENBE 515.124.4569 17-AUG-94
FI_MGR 12000 101 100
109 Daniel Faviet
DFAVIET 515.124.4169 16-AUG-94
FI_ACCOUNT 9000 108 100
112 Jose Manuel Urman
JMURMAN 515.124.4469 07-MAR-98
FI_ACCOUNT 7800 108 100
113 Luis Popp
LPOPP 515.124.4567 07-DEC-99
FI_ACCOUNT 6900 108 100
EMPLOYEE_ID FIRST_NAME LAST_NAME
EMAIL PHONE_NUMBER HIRE_DATE
JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- -------------------------
------------------------- -------------------- --------- ----------
---------- -------------- ---------- -------------
114 Den Raphaely
DRAPHEAL 515.127.4561 07-DEC-94
PU_MAN 11000 100 30
115 Alexander Khoo
AKHOO 515.127.4562 18-MAY-95
PU_CLERK 3100 114 30
116 Shelli Baida
SBAIDA 515.127.4563 24-DEC-97
PU_CLERK 2900 114 30
117 Sigal Tobias
STOBIAS 515.127.4564 24-JUL-97
PU_CLERK 2800 114 30
118 Guy Himuro
GHIMURO 515.127.4565 15-NOV-98
PU_CLERK 2600 114 30
119 Karen Colmenares
KCOLMENA 515.127.4566 10-AUG-99
PU_CLERK 2500 114 30
120 Matthew Weiss
MWEISS 650.123.1234 18-JUL-96
ST_MAN 8000 100 50
121 Adam Fripp
AFRIPP 650.123.2234 10-APR-97
ST_MAN 8200 100 50
122 Payam Kaufling
PKAUFLIN 650.123.3234 01-MAY-95
ST_MAN 7900 100 50
123 Shanta Vollman
SVOLLMAN 650.123.4234 10-OCT-97
ST_MAN 6500 100 50
124 Kevin Mourgos
KMOURGOS 650.123.5234 16-NOV-99
ST_MAN 5800 100 50
EMPLOYEE_ID FIRST_NAME LAST_NAME
EMAIL PHONE_NUMBER HIRE_DATE
JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- -------------------------
------------------------- -------------------- --------- ----------
---------- -------------- ---------- -------------
125 Julia Nayer
JNAYER 650.124.1214 16-JUL-97
ST_CLERK 3200 120 50
127 James Landry
JLANDRY 650.124.1334 14-JAN-99
ST_CLERK 2400 120 50
128 Steven Markle
SMARKLE 650.124.1434 08-MAR-00
ST_CLERK 2200 120 50
129 Laura Bissot
LBISSOT 650.124.5234 20-AUG-97
ST_CLERK 3300 121 50
130 Mozhe Atkinson
MATKINSO 650.124.6234 30-OCT-97
ST_CLERK 2800 121 50
131 James Marlow
JAMRLOW 650.124.7234 16-FEB-97
ST_CLERK 2500 121 50
132 TJ Olson
TJOLSON 650.124.8234 10-APR-99
ST_CLERK 2100 121 50
133 Jason Mallin
JMALLIN 650.127.1934 14-JUN-96
ST_CLERK 3300 122 50
134 Michael Rogers
MROGERS 650.127.1834 26-AUG-98
ST_CLERK 2900 122 50
135 Ki Gee
KGEE 650.127.1734 12-DEC-99
ST_CLERK 2400 122 50
136 Hazel Philtanker
HPHILTAN 650.127.1634 06-FEB-00
ST_CLERK 2200 122 50
EMPLOYEE_ID FIRST_NAME LAST_NAME
EMAIL PHONE_NUMBER HIRE_DATE
JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- -------------------------
------------------------- -------------------- --------- ----------
---------- -------------- ---------- -------------
137 Renske Ladwig
RLADWIG 650.121.1234 14-JUL-95
ST_CLERK 3600 123 50
138 Stephen Stiles
SSTILES 650.121.2034 26-OCT-97
ST_CLERK 3200 123 50
139 John Seo
JSEO 650.121.2019 12-FEB-98
ST_CLERK 2700 123 50
140 Joshua Patel
JPATEL 650.121.1834 06-APR-98
ST_CLERK 2500 123 50
141 Trenna Rajs
TRAJS 650.121.8009 17-OCT-95
ST_CLERK 3500 124 50
142 Curtis Davies
CDAVIES 650.121.2994 29-JAN-97
ST_CLERK 3100 124 50
143 Randall Matos
RMATOS 650.121.2874 15-MAR-98
ST_CLERK 2600 124 50
144 Peter Vargas
PVARGAS 650.121.2004 09-JUL-98
ST_CLERK 2500 124 50
145 John Russell
JRUSSEL 011.44.1344.429268 01-OCT-96
SA_MAN 14000 .4 100 80
146 Karen Partners
KPARTNER 011.44.1344.467268 05-JAN-97
SA_MAN 13500 .3 100 80
147 Alberto Errazuriz
AERRAZUR 011.44.1344.429278 10-MAR-97
SA_MAN 12000 .3 100 80
EMPLOYEE_ID FIRST_NAME LAST_NAME
EMAIL PHONE_NUMBER HIRE_DATE
JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- -------------------------
------------------------- -------------------- --------- ----------
---------- -------------- ---------- -------------
148 Gerald Cambrault
GCAMBRAU 011.44.1344.619268 15-OCT-99
SA_MAN 11000 .3 100 80
149 Eleni Zlotkey
EZLOTKEY 011.44.1344.429018 29-JAN-00
SA_MAN 10500 .2 100 80
150 Peter Tucker
PTUCKER 011.44.1344.129268 30-JAN-97
SA_REP 10000 .3 145 80
151 David Bernstein
DBERNSTE 011.44.1344.345268 24-MAR-97
SA_REP 9500 .25 145 80
152 Peter Hall
PHALL 011.44.1344.478968 20-AUG-97
SA_REP 9000 .25 145 80
153 Christopher Olsen
COLSEN 011.44.1344.498718 30-MAR-98
SA_REP 8000 .2 145 80
154 Nanette Cambrault
NCAMBRAU 011.44.1344.987668 09-DEC-98
SA_REP 7500 .2 145 80
155 Oliver Tuvault
OTUVAULT 011.44.1344.486508 23-NOV-99
SA_REP 7000 .15 145 80
156 Janette King
JKING 011.44.1345.429268 30-JAN-96
SA_REP 10000 .35 146 80
157 Patrick Sully
PSULLY 011.44.1345.929268 04-MAR-96
SA_REP 9500 .35 146 80
158 Allan McEwen
AMCEWEN 011.44.1345.829268 01-AUG-96
SA_REP 9000 .35 146 80
EMPLOYEE_ID FIRST_NAME LAST_NAME
EMAIL PHONE_NUMBER HIRE_DATE
JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- -------------------------
------------------------- -------------------- --------- ----------
---------- -------------- ---------- -------------
159 Lindsey Smith
LSMITH 011.44.1345.729268 10-MAR-97
SA_REP 8000 .3 146 80
160 Louise Doran
LDORAN 011.44.1345.629268 15-DEC-97
SA_REP 7500 .3 146 80
161 Sarath Sewall
SSEWALL 011.44.1345.529268 03-NOV-98
SA_REP 7000 .25 146 80
162 Clara Vishney
CVISHNEY 011.44.1346.129268 11-NOV-97
SA_REP 10500 .25 147 80
163 Danielle Greene
DGREENE 011.44.1346.229268 19-MAR-99
SA_REP 9500 .15 147 80
164 Mattea Marvins
MMARVINS 011.44.1346.329268 24-JAN-00
SA_REP 7200 .1 147 80
165 David Lee
DLEE 011.44.1346.529268 23-FEB-00
SA_REP 6800 .1 147 80
166 Sundar Ande
SANDE 011.44.1346.629268 24-MAR-00
SA_REP 6400 .1 147 80
167 Amit Banda
ABANDA 011.44.1346.729268 21-APR-00
SA_REP 6200 .1 147 80
168 Lisa Ozer
LOZER 011.44.1343.929268 11-MAR-97
SA_REP 11500 .25 148 80
169 Harrison Bloom
HBLOOM 011.44.1343.829268 23-MAR-98
SA_REP 10000 .2 148 80
EMPLOYEE_ID FIRST_NAME LAST_NAME
EMAIL PHONE_NUMBER HIRE_DATE
JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- -------------------------
------------------------- -------------------- --------- ----------
---------- -------------- ---------- -------------
170 Tayler Fox
TFOX 011.44.1343.729268 24-JAN-98
SA_REP 9600 .2 148 80
171 William Smith
WSMITH 011.44.1343.629268 23-FEB-99
SA_REP 7400 .15 148 80
172 Elizabeth Bates
EBATES 011.44.1343.529268 24-MAR-99
SA_REP 7300 .15 148 80
173 Sundita Kumar
SKUMAR 011.44.1343.329268 21-APR-00
SA_REP 6100 .1 148 80
174 Ellen Abel
EABEL 011.44.1644.429267 11-MAY-96
SA_REP 11000 .3 149 80
175 Alyssa Hutton
AHUTTON 011.44.1644.429266 19-MAR-97
SA_REP 8800 .25 149 80
176 Jonathon Taylor
JTAYLOR 011.44.1644.429265 24-MAR-98
SA_REP 8600 .2 149 80
177 Jack Livingston
JLIVINGS 011.44.1644.429264 23-APR-98
SA_REP 8400 .2 149 80
178 Kimberely Grant
KGRANT 011.44.1644.429263 24-MAY-99
SA_REP 7000 .15 149
179 Charles Johnson
CJOHNSON 011.44.1644.429262 04-JAN-00
SA_REP 6200 .1 149 80
180 Winston Taylor
WTAYLOR 650.507.9876 24-JAN-98
SH_CLERK 3200 120 50
EMPLOYEE_ID FIRST_NAME LAST_NAME
EMAIL PHONE_NUMBER HIRE_DATE
JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- -------------------------
------------------------- -------------------- --------- ----------
---------- -------------- ---------- -------------
181 Jean Fleaur
JFLEAUR 650.507.9877 23-FEB-98
SH_CLERK 3100 120 50
182 Martha Sullivan
MSULLIVA 650.507.9878 21-JUN-99
SH_CLERK 2500 120 50
183 Girard Geoni
GGEONI 650.507.9879 03-FEB-00
SH_CLERK 2800 120 50
184 Nandita Sarchand
NSARCHAN 650.509.1876 27-JAN-96
SH_CLERK 4200 121 50
185 Alexis Bull
ABULL 650.509.2876 20-FEB-97
SH_CLERK 4100 121 50
186 Julia Dellinger
JDELLING 650.509.3876 24-JUN-98
SH_CLERK 3400 121 50
187 Anthony Cabrio
ACABRIO 650.509.4876 07-FEB-99
SH_CLERK 3000 121 50
188 Kelly Chung
KCHUNG 650.505.1876 14-JUN-97
SH_CLERK 3800 122 50
189 Jennifer Dilly
JDILLY 650.505.2876 13-AUG-97
SH_CLERK 3600 122 50
190 Timothy Gates
TGATES 650.505.3876 11-JUL-98
SH_CLERK 2900 122 50
191 Randall Perkins
RPERKINS 650.505.4876 19-DEC-99
SH_CLERK 2500 122 50
EMPLOYEE_ID FIRST_NAME LAST_NAME
EMAIL PHONE_NUMBER HIRE_DATE
JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- -------------------------
------------------------- -------------------- --------- ----------
---------- -------------- ---------- -------------
192 Sarah Bell
SBELL 650.501.1876 04-FEB-96
SH_CLERK 4000 123 50
193 Britney Everett
BEVERETT 650.501.2876 03-MAR-97
SH_CLERK 3900 123 50
194 Samuel McCain
SMCCAIN 650.501.3876 01-JUL-98
SH_CLERK 3200 123 50
102 rows selected.
SQL> As I said in an earlier post: attention to detail is important.
David Fitzjarrell Received on Thu Apr 10 2008 - 08:27:11 CDT