Re: Select question

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