SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

View Definition

700193Mar 29 2011 — edited Mar 29 2011

Hi,
Can anyone tell me how to see full definition of a view? I have tried the below query

1. select text from all_views where name = view; -- it shows some 3-4 lines of the whole definition

also tried this one
select DBMS_METADATA.GET_DDL('VIEW','VIEW_NAME','SCHEMA_NAME') FROM DUAL ----- This also shows the first line of the whole definition only.

Can anyone why this is happening

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2011

Added on Mar 29 2011

8 comments

889 views