Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can i see full query of snapshot?
On 15 Jan 2002 05:08:05 -0800, sagi_at_bpath.com (sagi) wrote:
>I tried to read the query of a snapshot:
>select query from all_snapshots;
>but i only get part of the query.
>Does anyone can tell me how to do it?
set long <any large arbitrary number>
select query from all_snapshots
Hth
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Tue Jan 15 2002 - 11:39:42 CST