Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as Plain Text by DRINE ( 13 years ago )
CREATE TABLE TOP_SALARIES
(
SALARY NUMBER(8,2)
);
SET SERVEROUTPUT ON
DECLARE
CURSOR C_EMP_CURSOR IS SELECT SALARY FROM EMPLOYEES ORDER BY SALARY DESC;
V_NUM NUMBER:=&n;
SAL EMPLOYEES.SALARY%TYPE;
BEGIN
IF V_NUM=0 OR V_NUM>102 THEN
DBMS_OUTPUT.PUT_LINE('INVALID INPUT!');
ELSE
OPEN C_EMP_CURSOR;
LOOP
FETCH C_EMP_CURSOR INTO SAL;
EXIT WHEN C_EMP_CURSOR%ROWCOUNT>V_NUM OR C_EMP_CURSOR%NOTFOUND;
INSERT INTO TOP_SALARIES(SALARY) VALUES(SAL);
END LOOP;
CLOSE C_EMP_CURSOR;
END IF;
END;
SELECT * FROM TOP_SALARIES;
ROLLBACK TOP_SALARIES;
Revise this Paste