swap(num1, num2);
DBMS_OUTPUT.PUT_LINE('num1 = ' || num1); DBMS_OUTPUT.PUT_LINE('num2 = ' || num2); END;
6、CREATE FUNCTION staff1_fun (c1 IN CHAR)
RETURN staff%ROWTYPE AS
v1_staff staff%ROWTYPE;
BEGIN
SELECT * INTO v1_staff FROM staff WHERE sno=c1;
RETURN v1_staff;
END;
25
