Oracle数据库应用 复习题及答案

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