text from user_views
407048Aug 5 2004 — edited Nov 28 2007From sqlplus, I did a
set long 2000
And then said -
SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME = 'EMP_VIEW';
However, I just cannot see the whole view text. A part of it is getting cut off and cannot see it wholly.
Any ideas ? Thanks