Pl/Sql statements and examples

Q. Write Pl/sql cursor declaration to store employee code(EMPNO), employee name(ENAME) of employees form Emp table who are located (LOC) in Delhi. [CBSE D 07 : 2marks]

Cursor emp_c1 is
Select empno, ename
From Emp
Where loc = ‘Delhi’;

SIMILAR QUESTIONS FOR PRACTICE (LIKE ABOVE Q.)

Q. Write Pl/sql cursor declaration to store emp code(EMPNO), employee name(ENAME) of employees from Emp table whose designation is salesman.
Cursor emp_c1 is
Select empno, ename
From Emp
Where design = ‘salesman’;
Q. Write Pl/sql cursor declaration to store student id(STU_ID), student name(STU_NAME), student class(STU_CL) of student from STUDENT table who score marks less than 40%.
TRY IT