User's Manual

Using PL/SQL to Capture Business Logic
Beta Draft Executing Stored Procedures and Functions 6-3
7.
In the Oracle Database XE Login page, enter the Username hr and Password hr.
Click Login:
8. In the Home page, click the arrow on the SQL icon, move the mouse over SQL
Commands and click Enter Command:
9. In the SQL Commands page, enter the following text to create a
calc_remuneration() function:
create or replace function calc_remuneration(
salary IN number, commission_pct IN number) return number is
begin
return ((salary*12) + (salary * 12 * nvl(commission_pct,0)));
end;
Click Run: