| pl/sql ? [message #1232] |
Fri, 12 April 2002 12:29  |
Jack Brown
Messages: 4
Registered: April 2002
|
Junior Member |
|
|
|
I am aware that in pl/sql only a subquery can be written with a select statement. Is there any way to get'select * from table;" output from a pl/sql code.
|
|
|
|
| Re: pl/sql ? [message #1234 is a reply to message #1232] |
Fri, 12 April 2002 13:16  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
u can get any columns in output.
-----------------------
SQL> get h
1 set serveroutput on;
2 declare
3 cursor c1 is select * from emp;
4 begin
5 for mag in c1 loop
6 dbms_output.put_line(mag.ename||','||mag.empno||', '||mag.sal);
7 end loop;
8* end;
SQL> @h
SMITH,7369, 800
ALLEN,7499, 1600
WARD,7521, 1250
JONES,7566, 2975
MARTIN,7654, 1250
BLAKE,7698, 2850
CLARK,7782, 2450
SCOTT,7788, 3000
KING,7839, 5000
TURNER,7844, 1500
ADAMS,7876, 1100
JAMES,7900, 950
FORD,7902, 3000
MILLER,7934, 1300
PL/SQL procedure successfully completed.
SQL>
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
