Re: Using dynamic SQL in Developer 2000

The only way I know to get dynamic SQL into Developer is to programatically change the default where clause for the block you are working on. My experience in actually doing this is null, but I've been told it does work.

Dan

In article <339C10D5.55D2_at_iil.intel.com>, Maoz says...
>
>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)
  Received on Mon Jun 09 1997 - 00:00:00 CEST