Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic sql from FORMS 4.5
In article <Pine.SOL.3.91.970516082341.29820A-100000_at_biotec>, Abiy says...
>
>Hi friends,
>
>I would like to make a SELECT statement (dynamically) from FORMS 4.5.
>Is it possible to make a FORMS_DDL('SELECT INTO something ...') ? Or is
Well, the only way to "dynamicly" set a WHERE clause is SET_BLOCK_PROPERTY. Use it to specify the "default" WHERE clause for the block. I've not tried this, but I've heard that it works.
Hope this helps.
Dan Received on Fri May 16 1997 - 00:00:00 CDT