Re: Table name as input: HOW

[Quoted] You will have to use dbms_sql. Create your query string at runtime and pass [Quoted] it into the dbms_sql package. All good books should have a section on dbms_sql.

Mark

Norhamizan Arifin wrote in message <37707B01.6B1B04B3_at_mimos.my>...
>
>I know that this SELECT statement can be done in SQL Plus:
>
> 1* select * from &table_name
>SQL> /
>Enter value for table_name:
>
>But how to do it in a form. And get the input may be from textbox or
>variable. And then display all the records.
>
>Please help.
>
>Thanks in advance.
>
>../Mizan
Received on Wed Jun 23 1999 - 10:15:47 CEST