Re: Any expert Pro*C/C++ programmer out there?

On Mar 13, 2:58 am, Laurenz Albe <inv..._at_spam.to.invalid> wrote:
> Ramon F Herrera <r..._at_conexus.net> wrote:
>
> > In my application, the critical variable which is only known at run
> > time is none less than the table name. It is something like this:
>
> > SELECT emp_name FROM $table_name WHERE emp_id = :some_unique_id;
>
> I think that 'dynamic SQL' is what you are looking for.
>
> Yours,
> Laurenz Albe

Exactly. Oracle provides four ways to use Dynamic SQL:

• Method 1
• Method 2
• Method 3
• Method 4

The first two cannot be used in queries (SELECT) and the last one is more than I need. Therefore, I have to use Method 3.

-Ramon Received on Tue Mar 13 2007 - 17:55:09 CDT