Coding Atharva: Cursor

Showing posts with label Cursor. Show all posts

WRITE A PL/SQL PROGRAM USING FOR LOOP IN CURSOR TO PRINT NAME JOB IF EMPLOYEE HAVING DESIGNATION AS MANAGER OR ANAYST

-- USING FOR LOOP DECLARE CURSOR C1 IS SELECT ENAME,JOB FROM EMP; BEGIN FOR R IN C1 LOOP IF R.JOB='MANAGER...

--SINGLE QUERY SELECT * FROM EMP WHERE SAL IN (SELECT * FROM (SELECT DISTINCT SAL FROM EMP ORDER BY SAL DESC) WHERE ROWNUM<5) --...

--> 1 STATE THE OUTPUT DECLARE CURSOR C1 IS SELECT * FROM EMP WHERE SAL=7000; EMP_REC C1%ROWTYPE; BEGIN DBMS_OUTPUT.PUT_LINE...

TO PRINT RECORD OF 4TH,6TH AND 8TH DECLARE CURSOR C1 IS SELECT * FROM EMP; I INT:=0; BEGIN FOR R IN C1 LOOP I:=I+1; IF ...

PROGRAM FOR DISPLAYING EMPLOYEE WORKING IN COMPUTER DEPARTMENT DECLARE CURSOR C1 IS SELECT ENAME,SAL,DNAME FROM EMP,DEPT WHERE EMP.DEPTN...

CL SCR : TO CLEAR THE SCREEN *********************************************** SQL> DECLARE 2 VENO EMP.EMPNO%TYPE; 3 BEGIN ...

SQL> set pagesize 200; SQL> set serveroutput on; ****************************************** DECLARE CURSOR C1 IS SELECT ENAME...