Re: Where can we get WHERE clause after executing Forms Query?

Hi,

Coming from a Server perspective, you can track the SQL down from v$sqlarea, but you need to know a search pattern that can be passed to the select statement.

Andrew

armaghan_at_usa.net wrote:

> Where can we get WHERE clause after executing Forms Query?
>
> GET_BLOCK_PROPERTY(block_name, DEFAULT_WHERE) returns the where clause which
> we set in design mode. It does not include WHERE for the query.
>
> Any idea will help.
>
> Regards,
> M. Armaghan Saqib
> Oracle Link for XL - A free tool to get data from / to Oracle Databases.
> Send mail to armaghan_at_geocities.com with subject "VIA EMAIL" to receive this
> tool via email. (size: 98 kb)
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Apr 26 1999 - 05:48:11 CEST