10/27/18 ~ Coding Atharva

Schema Table Used For Queries

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

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

PL/SQL NOTES

--1>STATE THE OUTPUT DECLARE I NUMBER:=0; BEGIN LOOP DBMS_OUTPUT.PUT_LINE('I='||I); I:=I+1; EX...

ACCEPT THREE NUMBER AND DISPLAY LARGEST ONE DECLARE A INT; B INT; C INT; LARGE INT; BEGIN A:=&A; B:=&B; C:=&C; IF A...

EVEN NUMBER BETWEEN 1 TO 100 DECLARE NUM INT; BEGIN DBMS_OUTPUT.PUT_LINE('EVEN NUMBERS: '); FOR NUM IN 1..100 LOOP IF MOD(N...