Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select Statement help
You can use dbms_sql to dynamically create queries, execute them and get
values from the columns, where the column list, table, and where clause are
determined at runtime.
--
- Dan Clamage
http://www.telerama.com/~dclamage
If you haven't crashed the Server,
you haven't been trying hard enough.
Ken Stevens <ken.stevens_at_srs.gov> wrote in article
<1998Jul23.083857.10605_at_srs.gov>...
> Is there a way to select a value of a local variable in a select
> statement. Example: let's say I have column name from a table stored in
> a local variable. I want to beable to dynamically change the column name
> in the variable and then select the column name from the variable in the
> select statement. Is this possible?
>
>
> Thanks in advance,
>
>
> Ken
>
> --
> Ken Stevens | ken.stevens_at_srs.gov |
> Views and opinions expressed are my own and in no way represent
> implicitly or explicitly views and opinions of WSRC or DOE.
>
Received on Fri Jul 24 1998 - 21:27:19 CDT