Re: procedure question

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Wed, 28 Jul 1999 07:50:17 -0400
Message-ID: <379EEE78.63AE48BE@Unforgettable.com>

Linda White wrote:

> 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.

Is this homework? Those are the infamous SCOTT tables. Received on Wed Jul 28 1999 - 06:50:17 CDT