Help - Search - Members - Calendar
Full Version: how to inherit value into another SQL statement??
Oracle DBA Forums > Oracle > Oracle Forum
VanessaHung
Dear all..

How to inherit value from SQL A to SQL B ??
ex: select col a, col b, col c from table a where condition ....
I need col c to inherit into next SQL.
select col d, col e from table b where condition A= col c.

I'm not a programmer , I already tried to use procedure to do so .
But it still can't be done.
Did I miss something?? Any sample code to help me??
dave
just select c into a variable
SteveC
http://www.dba-oracle.com/t_with_clause.htm
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.