Re: Dinamic SQL

This works in SQL :

col table_name new_value table_name

select table_name table_name
from all_tables
where table_name = 'GL_CODE_COMBINATIONS'; --or whatever statement you want to

                                                --derive table_name

select count(*)
from &&table_name;

Not sure if this works in Forms 5.0 (the col part!)

Starman wrote:
>
> Curtis Holbrook <cholbroo_at_concentric.net> wrote in message
> 3814790B.FB1D5927_at_concentric.net...
> > What environment are you using: SQL*Plus, Pro-C, OCI??
>
> You're right, I forgot to write this information. I'm working in Forms 5.0
>
> Thanks for helping
>
> --
> Nino Stella
> Inteldata Srl
> email: ninomail_at_tin.it

Received on Tue Oct 26 1999 - 08:39:08 CDT