Re: Live Chat - Oracle 8i PL/SQL Features
From: <hafizmohammed00_at_gmail.com>
Date: Thu, 15 Dec 2016 01:02:11 -0800 (PST)
Message-ID: <500dc91a-8f5f-4070-83a0-8117d2af7009_at_googlegroups.com>
Date: Thu, 15 Dec 2016 01:02:11 -0800 (PST)
Message-ID: <500dc91a-8f5f-4070-83a0-8117d2af7009_at_googlegroups.com>
hello i need a help...on plsql..and this is the question....
create a procedure called updateempbonus that tskes
department id as a parameter
update employee salary based on the following
if the employee has been in employment for up to 10years,and 200 to his or her salary
between 9 and 8 years,add 18o to this or her salary between 7 and 5 years,add 15o to this or her salary between 4 and 3 years,add 10o to this or her salary2 or less years, add 0 to his or her salary Received on Thu Dec 15 2016 - 10:02:11 CET