DDL for VIEW

[saira78]

How would you go about finding how a view was created if you weren't the one creating it?

I have to alter a view but I can't without information about the original view.

Thanks,
Saira

 

[saira78]

Using ALL_VIEWS I can extract the TEXT column, however, it will only display the first x number of characters like this:

TEXT
--------------------------------------------------------------------------------
(
SELECT A.WHSE_CODE,A.ITEM_NUM,B.LAST_COST FROM ITEM_W A,(SELECT DISTINCT (LAST

How do I go about getting the rest of the view definition?

Thanks all,
Saira

 

[saira78]

Silly me.

SQL> set LONG <anynumber>
SQL> <execute your select>