Coding Atharva: Data Base Management System (Oracle)

Showing posts with label Data Base Management System (Oracle). 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...

Program to perform Simple Switch CASE in PL/SQL In this Switch case is same as in C language. Only the differenc...

Program to perform EXIT statement: DECLARE A int; BEGIN A:=10; LOOP DBMS_OUTPUT.PUT_LINE(A); A:=A+10; IF A>10...

Program to perform Searched Switch CASE in PL/SQL In this Switch case is same as in C language. Only t...

Program to perform GOTO statement in PL/SQL In PL/SQL GOTO statement is same as in C language.It move the c...

****************************************************************************** Employee Table: CREATE TABLE EMP(EMPNO INT UNIQUE,ENAME V...

****************************************************************************** Employee Table: CREATE TABLE EMP(EMPNO INT UNIQUE,ENAME V...

PL/SQL NOTES