Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Select question

Re: Select question

From: Mserban <mserban_at_aol.com>
Date: 1997/03/24
Message-ID: <19970324060700.BAA20063@ladder01.news.aol.com>#1/1

Try this:

In SQL*Plus, see how the LONG parameter is set:

SHOW LONG (default is 80)

Set it to a very large value (2000 should do it):

SET LONG 2000 Check the value again: SHOW LONG

Then SELECT sql_text FROM v$sqltext (or v$sqlarea) WHERE ...

I hope this helps.

Michael Serbanescu
Senior Consultant, MIACO Corporation Received on Mon Mar 24 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US