oracle view

SQL> set linesize 10000

SQL> set long 10000

SQL> set pagesize 60

SQL> select text from all_view where view_name = 'MY_VIEW_NAME';