spy DBMS

Display salary and ename using cursor

Jul 31, 20231 min read

declare cursor c1 is select * from emp; e emp %rowtype; begin open c1; loop fetch c1 into e; exit when c1 %notfound; dbms_output.put_line(e.ename ||...

wap for NO_DATA_FOUND Exception

Jul 31, 20231 min read

DECLARE vno NUMBER(5) := :vno; vname emp.ename%TYPE; BEGIN SELECT ename INTO vname FROM emp WHERE empno = vno; DBMS_OUTPUT.PUT_LINE(vno || ' ' ||...

wap for assign bounds based on job and salary

Jul 31, 20231 min read

declare cursor c1 is select * from emp; e emp %rowtype; net number(10); bonus number(10); begin open c1; loop fetch c1 into e; exit when c1...

Write a function to return net salary of a given employee

Jul 31, 20231 min read

CREATE OR REPLACE FUNCTION net_sal(vno NUMBER) RETURN NUMBER IS vsal emp.sal%TYPE; vcomm emp.comm%TYPE; net NUMBER(10); BEGIN SELECT sal, comm...

WAP to display all managers data from emp table using cursor for loop

Jul 31, 20231 min read

DECLARE CURSOR c1 IS SELECT * FROM emp WHERE job = 'MANAGER'; BEGIN DBMS_OUTPUT.ENABLE; FOR i IN c1 LOOP DBMS_OUTPUT.PUT_LINE(i.empno || ' ' ||...

Value error exception in plSQL

Jul 31, 20231 min read

DECLARE temp_number NUMBER; temp_string VARCHAR2(10) := 'BLAKE'; BEGIN temp_number := temp_string; EXCEPTION WHEN VALUE_ERROR THEN ...