Home » SQL & PL/SQL » Client Tools » SQL_TEXT in sqlplus screen (Generic )
SQL_TEXT in sqlplus screen [message #403793] Mon, 18 May 2009 14:07 Go to next message
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 ............
Re: SQL_TEXT in sqlplus screen [message #403795 is a reply to message #403793] Mon, 18 May 2009 14:15 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
SQL> SET LONG 32000
Re: SQL_TEXT in sqlplus screen [message #403803 is a reply to message #403793] Mon, 18 May 2009 17:37 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
You'll probably also want to select sql_fulltext rather than sql_text.
Previous Topic: Migrating Pro*PL1 to PL/SQL
Next Topic: SQL Navigator not working
Goto Forum:
  


Current Time: Fri Dec 09 17:44:45 CST 2016

Total time taken to generate the page: 0.18753 seconds