Wednesday, September 13, 2006

How to retrieve view definition?

set long 500000000
set arraysize 1
set maxdata 50000

>select text from user_viewswhere view_name = 'Whatever';

If your dont set above parameters, text comes truncated.

No comments: