Re: dynamic SQL statement

Thomas Chen wrote:
>
> To ORACLE experts out there:
> Is there anyway to build a dynamic SQL frontend?
> The application is CGI for Web Page interface to ORACLE
> and based on which option the user select on the page,
> the interface would QUERY the database (therefore it has
> to be dynamic). Since SQL/PL seems to require compile
> time preprocess, is there a solution to this problem?
>
> TomTom

take a look at DBMS_SQL (I think). Allows you to create dynamic SQL. Works well !

Rob

-- 
**************************
Rob Benson
Theta Systems Limited
robben_at_theta.co.nz
http://theta.co.nz/theta