OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » select query (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

select query [message #612229]

Mon, 14 April 2014 22:28

foopaloop
Messages: 1
Registered: March 2010

Junior Member

Dear all

I am new to sql programming and I need some help. I would like to know how can I take the output of one select statement and use it as an input for another query. Do I need to use a stored procedure for this?

Please let me know if you would like to see the code that I'm using at the moment.

Thanks

Report message to a moderator

Re: select query [message #612230 is a reply to message #612229]

Mon, 14 April 2014 22:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

If you know neither SQL nor PL/SQL, you are biting off more than you can chew.

Is below close to what you want to do?

SQL> select ename from emp where deptno in (select deptno from dept where dname = 'SALES');

ENAME
----------
WARD
TURNER
ALLEN
JAMES
BLAKE
MARTIN

6 rows selected.

Report message to a moderator

Previous Topic:	(non)Matching nulls
Next Topic:	how to remove columns not ending with leaf nodes in hierarchical queries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 16:27:33 CDT 2024