How to script a Table or View in SQL Plus

[Fampofo]

Hello Guys
Is it possible to script the sql statement of a view or a table from sql plus command line ?
I am working on an ODBC via Access and I need to see the sql statement of this view. Help will be much appreciated.
thanks
frank

 

[sem]

View text:


select text from user_views where view_name=<view name>


For 9i and above you may use DBMS_METADATA.GET_DDL procedure.

Regards, Dima

http://seminihin.narod.ru

 

[sbix]

if the code of the view is a little bit long, by the moment TEXT is a LONG type field, you have to issue a command like:
SET LONG 2000
prior to run SQL the SQL command posted by sem