Welcome, guest! Login / Register - Why register?
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

Your Name: Code Language: