Natija: Minimum of (23, 45) : 23
PL/SQL procedure successfully completed.
Misol. Sonning kvadratini aniqlash protsedurasini yarating.
DECLARE
a number;
PROCEDURE squareNum(x IN OUT number) IS
BEGIN
x := x * x;
END;
BEGIN
a:= 23;
squareNum(a);
dbms_output.put_line(' Square of (23): ' || a);
END;
Natija: Square of (23): 529
PL/SQL procedure successfully completed.
PL/SQL da funksiyalar bilan ishlash. Funksiyalar protseduralardan
farqli ravishda natijani qaytaruvchi xossaga ega bo‘ladi. Funksiyani e’lon
qilish:
CREATE [OR REPLACE] FUNCTION function_name [(parameter_name [IN | OUT | IN OUT] type [, ...])] RETURN return_datatype {IS | AS} BEGIN < function_body > END [function_name]; Misol. CREATE OR REPLACE FUNCTION totalCustomers
RETURN number IS
total number(2) := 0;
BEGIN
SELECT count(*) into total
FROM customers;
RETURN total;
END;
Funsiya’ni chaqirish DECLARE
c number(2);
BEGIN
c := totalCustomers();
DBMS_OUTPUT.PUT_LINE('Total no. of Customers: ' || c);
END;
Misol. Ikkita sondan kattasini aniqlash funksiyasi
DECLARE
a number;
b number;
c number;
FUNCTION findMax(x IN number, y IN number)
RETURN number
IS
z number;
BEGIN
IF x > y THEN
z:= x;
ELSE
Z:= y;
END IF;
RETURN z;
END;
BEGIN
a:= 23;
b:= 45;
c := findMax(a, b);
DBMS_OUTPUT.PUT_LINE(' Maximum of (23,45): ' || c);
END;
