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

Comments embedded.
On Apr 10, 10:28 am, chris <lazyboy..._at_yahoo.com> wrote: [thread history snipped]
>
> Thanks a lot David & I really appreciate your helps.  

You're welcome.

> After examine
> the codes, I knew datatype violation came from hire_date, but didn't
> know how to solve it at the time.  Well, I made a little bit of
> modification on the script & it's working fine now.  Thanks.  here is
> what I have done...
>
> ..........
> CURSOR emp_cursor IS
>          SELECT employee_id  empno,  first_name  fname, last_name
> lname, email  email_addr,
>                 phone_number  phoneno, hire_date  hiredate, job_id
> jobid, salary  sal,
>                 commission_pct  comm, manager_id  mgr_id,
> department_id   deptno
>          FROM employees;
>
> BEGIN
>       FOR emp_rec IN emp_cursor LOOP
>              IF TO_CHAR(emp_rec.hiredate, 'month') =  'september' THEN
> ........
>
> And I use "emp_rec.hiredate" to insert into the tables.

Sometimes all that is required is an example.

David Fitzjarrell Received on Thu Apr 10 2008 - 14:17:13 CDT