SQL> set serveroutput on
SQL> @c:\seit\abc.sql;
SQL> DECLARE
2 Cursor ecursor is select ename,sal from emp order by sal desc;
3 name emp.ename%type;
4 sal emp.sal%type;
5 BEGIN
6 open ecursor;
7 DBMS_OUTPUT.put_line('top 5 paid employees');
8 For I In 1..5
9 Loop Fetch ecursor into name,sal;
10 DBMS_OUTPUT.put_line(name);
11 DBMS_OUTPUT.put_line(sal);
12 End loop;
13 END;
14 /
top 5 paid employees
KING
5000
SCOTT
3000
FORD
3000
JONES
2975
BLAKE
2850
PL/SQL procedure successfully completed.
Subscribe to:
Post Comments (Atom)
-
Practical exam Q No. 1 Q-1> Write a query in sql to create a table employee and department. Employee(empno,ename,deptno,job,hiredate...
-
Answers Experiment No. 1 1. SQL> create table deptit(deptno number(2) primary key,dname varchar(14) not null,loc varchar(13) not null); T...
-
4.2 Decomposition Techniques As mentioned earlier, one of the fundamental steps that we need to undertake to solve a problem in parallel...
No comments:
Post a Comment