Trees and Graphs Notes Download Notes
Read More
STACKS AND QUEUES NOTES
STACKS AND QUEUES NOTES Download Notes
Read More
PRACTICAL EXAM QUESTIONS C++
PRACTICAL EXAM QUESTIONS
Read More
Linked List Notes
Linked List Notes Download Notes
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 USING CURSOR TO PRINT NAME JOB IF EMPLOYEE HAVING DESIGNATION AS MANAGER OR ANALYST
PROGRAM USING CURSOR TO PRINT NAME JOB IF EMPLOYEE HAVING DESIGNATION AS MANAGER OR ANALYST DECLARE CURSOR C1 IS SELECT ENAME,JOB FROM ...
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
Subscribe to:
Posts (Atom)
