Home » SQL & PL/SQL » SQL & PL/SQL » Using query results in next query...is it possible?
Using query results in next query...is it possible? [message #1026] Thu, 21 March 2002 13:02 Go to next message
Tom
Messages: 67
Registered: June 1998
Member
Is there a way in PL/SQL to use a result set (e.g. cursor), created from a previous query, in the next query? I just can't seem to find a way to do this. I must be missing the obvious.

Any help would be greatly appreciated. Thanks.
Re: Using query results in next query...is it possible? [message #1030 is a reply to message #1026] Thu, 21 March 2002 19:54 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
assume the first query is
select deptno from emp;

select empno,ename,sal from emp where deptno in (select deptno from emp);

sai
Previous Topic: UPDATE TABLE FROM ANOTHER
Next Topic: help in simple sql statement
Goto Forum:
  


Current Time: Fri Mar 29 00:25:50 CDT 2024