Oracle B25-317-01 Instrukcja Użytkownika Pobierz pdf (Strona 65)

Using PL/SQL to Capture Business Logic

Beta Draft Executing Stored Procedures and Functions 6-3

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:

1 2 ... 60 61 62 63 64 65 66 67 68 69 70 ... 93 94

Brak uwag

Oracle B25-317-01 Instrukcja Użytkownika Strona 65