Re: Using dynamic SQL in Developer 2000

Maoz Mussel wrote:
>
> Hi,
>
> I would like to run dynamic SQL statement in Developer 2000.
> In particular, I would like to run the following query:
> SELECT count (*) FROM table_name WHERE|| where_var
>
> Where 'where_var' will be a variable including the where statement.
> I know I should be doing it using DBMS_SQL (is there another way ???),
> but:
> 1) Current version of D2k doesn't support pl/sql 2 which I need to
> run such a query.
> 2) I try to run it directly from the server, and couldn't found the
> correct syntax.
>
> If you have an example to what I need, and/or can advice me some
> more on this subject, please reply.
>
> Thanks in advance,
> Maoz
> (mmussel_at_iil.intel.com)

[Quoted] The simplest way to dynamically construct a SELECT statement is via FORMS record groups. There are a number of builtins but the one I use the most is CREATE_GROUP_FROM_QUERY.

Al Lawson
Interactive Group, Inc.
www.interactive-group.com
lawsona_at_interactive-group.com Received on Wed Jun 11 1997 - 00:00:00 CEST