Re: pl/sql: display employees who hired in specific month

On Apr 9, 5:32 pm, chris <lazyboy...@xxxxxxxxx> wrote:
On Apr 9, 11:50 am, "fitzjarr...@xxxxxxx" <orat...@xxxxxxx> wrote:





Comments embedded.
On Apr 9, 12:42 pm, chris <lazyboy...@xxxxxxxxx> 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
.

Relevant Pages