You might want to look up UPDATE, AVG, MAX, and WHERE. I don't know what
fields are in each of your tables. It's not that hard of a problem.
--rn.
Linda White <hpya78_at_postoffice.pacbell.net> wrote in message
news:379EB5AE.385CB568_at_postoffice.pacbell.net...
> Hi,
> I am new in ORACLE. I have 3 tables emp, salgrade, dept.
>
> Can anyone help me create a procedure that will give a raise to any
> employee hired
>
> before 01-JAN-83 whose current salary is less then the current average
> salary
>
> for their department. The raise is to equal to $30 for every month of
> employment prior to
>
> 01-JAN-83. Their new salary is not exceed the upper limit of their
> current pay grade.
>
>
> THANK
>
>
>
>
Received on Sun Aug 01 1999 - 17:46:27 CDT
