-- USING FOR LOOP DECLARE CURSOR C1 IS SELECT ENAME,JOB FROM EMP; BEGIN FOR R IN C1 LOOP IF R.JOB='MANAGER...
Read More
Showing posts with label Data Base Management System (Oracle). Show all posts
Showing posts with label Data Base Management System (Oracle). Show all posts
Program to perform Simple Switch CASE in PL/SQL
Program to perform Simple Switch CASE in PL/SQL In this Switch case is same as in C language. Only the differenc...
Read More
Program to perform EXIT statement in PL/SQL
Program to perform EXIT statement: DECLARE A int; BEGIN A:=10; LOOP DBMS_OUTPUT.PUT_LINE(A); A:=A+10; IF A>10...
Read More
Program to perform Searched Switch CASE in PL/SQL
Program to perform Searched Switch CASE in PL/SQL In this Switch case is same as in C language. Only t...
Read More
Program to perform GOTO statement in PL/SQL
Program to perform GOTO statement in PL/SQL In PL/SQL GOTO statement is same as in C language.It move the c...
Read More
Schema Table Used For Queries
****************************************************************************** Employee Table: CREATE TABLE EMP(EMPNO INT UNIQUE,ENAME V...
Read More
Write the Query in Oracle For Employee table
****************************************************************************** Employee Table: CREATE TABLE EMP(EMPNO INT UNIQUE,ENAME V...
Read More
PL/SQL NOTES
PL/SQL NOTES
Read More
STATE THE OUTPUT FOR PL/SQL CODE
--1>STATE THE OUTPUT DECLARE I NUMBER:=0; BEGIN LOOP DBMS_OUTPUT.PUT_LINE('I='||I); I:=I+1; EX...
Read More
WRITE A PL/SQL PROGRAM FOR ACCEPTING THREE NUMBER AND DISPLAY LARGEST ONE
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...
Read More
WRITE A PL/SQL PROGRAM FOR EVEN NUMBER BETWEEN 1 TO 100
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...
Read More
WRITE A PL/SQL PROGRAM FACTORIAL OF GIVEN NUMBER BY USING WHILE LOOP
FACTORIAL OF GIVEN NUMBER BY USING WHILE LOOP DECLARE NUM NUMBER(3); FACT NUMBER(10); BEGIN NUM:=# FACT:=1; DBMS_OUTPUT.PUT...
Read More
WRITE A PL/SQL PROGRAM TO DISPLAY 1 TO 10 IN REVERSE ORDER USING FOR LOOP
TO DISPLAY 1 TO 10 IN REVERSE ORDER DECLARE I NUMBER:=10; BEGIN DBMS_OUTPUT.PUT_LINE('REVERSE NUMBER 1-10 '); FOR I IN REVER...
Read More
WRITE A PL/SQL PROGRAM UPDATE THE SALARY BY 15% WORKING IN RESEARCH AND STORE USING CURSOR
--SINGLE QUERY SELECT * FROM EMP WHERE SAL IN (SELECT * FROM (SELECT DISTINCT SAL FROM EMP ORDER BY SAL DESC) WHERE ROWNUM<5) --...
Read More
STATE THE OUTPUT FOR CURSOR
--> 1 STATE THE OUTPUT DECLARE CURSOR C1 IS SELECT * FROM EMP WHERE SAL=7000; EMP_REC C1%ROWTYPE; BEGIN DBMS_OUTPUT.PUT_LINE...
Read More
WRITE A PL/SQL PROGRAM TO PRINT RECORD OF 4TH,6TH AND 8TH USING CURSOR
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 ...
Read More
WRITE A PL/SQL PROGRAM FOR DISPLAYING EMPLOYEE WORKING IN COMPUTER DEPARTMENT USING CURSOR
PROGRAM FOR DISPLAYING EMPLOYEE WORKING IN COMPUTER DEPARTMENT DECLARE CURSOR C1 IS SELECT ENAME,SAL,DNAME FROM EMP,DEPT WHERE EMP.DEPTN...
Read More
STATE THE OUTPUT In Exception Handling
--1> STATE THE OUTPUT DECLARE stock_price number := 9.73; NET_EARNINGS NUMBER:=0; PE_RATIO NUMBER; BEGIN PE_RATIO := STOC...
Read More
Super Shop Management System
Super Shop Management System Program Name - Computer Engineering Program Code – CO-3-I Course Name – Database Ma...
Read More
DML Triggers in PL/SQL
***************************************************** CREATE OR REPLACE TRIGGER EMPTRG BEFORE UPDATE ON EMP BEGIN DBMS_OUTPUT.PUT_LI...
Read More
Subscribe to:
Posts (Atom)
