OraFAQ Forum: Client Tools » SQL_TEXT in sqlplus screen

Home » Other » Client Tools » SQL_TEXT in sqlplus screen (Generic )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL_TEXT in sqlplus screen [message #403793]

Mon, 18 May 2009 14:07

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

I am trying to get SQL_TEXT from SQLAREA but it always get truncated and i am not getting full text.tried set pages etc.. still its getting truncated. Any idea what would be the best sqlplus settings to get this in screen .
Thanks

SELECT t.SQL_TEXT
  FROM V$SESSION s, V$SQLAREA t, V$STREAMS_APPLY_SERVER a
  WHERE ............

Report message to a moderator

Re: SQL_TEXT in sqlplus screen [message #403795 is a reply to message #403793]

Mon, 18 May 2009 14:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> SET LONG 32000

Report message to a moderator

Re: SQL_TEXT in sqlplus screen [message #403803 is a reply to message #403793]

Mon, 18 May 2009 17:37

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

You'll probably also want to select sql_fulltext rather than sql_text.

Report message to a moderator

Previous Topic:	Migrating Pro*PL1 to PL/SQL
Next Topic:	SQL Navigator not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 02:14:07 CST 2025