Re: Select question

From: Mario Methot <methotm_at_berclain.com>
Date: 1997/03/20
Message-ID: <01bc3569$14a299d0$5e2613cc@wntmme>#1/1

Hi Andrea,

You can select sql_text from v$sqlarea where... to obtain your information. You can use a 'like' operator to reduce the number of records return by the query.

Mario Methot
DBA
Berclain Group
Quebec, Canada

Andrea Pallotta <anpallotta_at_flashnet.it> wrote in article <01bc34b7$ceec8d80$49a1f7c2_at_rm03772>...
> Hi there!!!
>
> Another question for you...
>
> Can i see the text of a SQL statement after its execution??
> I tried with the v$sqltext, but the results are not complete...
>
>
> If you have some suggest...
>
> Thanks in advance
>
> Andrea Pallotta
> Digital Italia
> Gruppo di Sviluppo
>
Received on Thu Mar 20 1997 - 00:00:00 CST