view text from all_views

[ganesh]

I am trying to get the script of view using all_views , text column. When I spool it in sqlplus, I am not able to get the
full text in the file.

Am I missing something.

Also, as the text is a long column , I am not able to do a
substr or any operation on that. I am sure there is a
round about way to do this.

Can somebody help me on this.

[jmodic]

In SQL*Plus the default is to display only first 80 (or is it 100?) characters. If you want to see more, set it to higher value:

SET LONG = 1000

and you'll be able to see the first 1000 characters...