Re: When curosr_Sharing=force how to find the original statement

zigzagdna_at_yahoo.com wrote:
> I am supporting a ERP application, do not have access to source code.
> crsor_sharing is set to force so when I look in v$sql etc it shows me
> the statement with various bind varaiables. Is there any way to find
> the original query before Oracle replaced literals by bind variables.
>
> Thanks.

select view_name from dba_views
where view_name like '%BIND%';

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org