SEO

#1 (**permalink**) 02-26-2008, 06:49 AM

I have an Oracle procedure in which I am calling a select statement. I
need to use the results of this select statment and do something and
form another select statement.

select a, b, c ....

I need to use a, b, c to do something to get
d, e, f

I need to make another select as
select d, e,f ..
use it in a report.

How can I do this?

#2 (**permalink**) 02-26-2008, 06:49 AM

ind_123 wrote:
> I have an Oracle procedure in which I am calling a select statement. I
> need to use the results of this select statment and do something and
> form another select statement.
>
> select a, b, c ....
>
> I need to use a, b, c to do something to get
> d, e, f
>
> I need to make another select as
> select d, e,f ..
> use it in a report.
>
> How can I do this?

Native Dynamic SQL

Go to Morgan's Library at www.psoug.org and scroll down until you find
the link to the demos.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Call a cursor in another