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!

sql query shows partial output only.

873503Jul 6 2011 — edited Jul 6 2011

Hi ,

When I tried to display the source code of a view from the following query,I'm able to see partial output only as below.

SQL> select text from user_views where view_name ='ABC';

TEXT
--------------------------------------------------------------------------------
SELECT Region,
product_director,
plan_year,

where as the TEXT should be about 200 lines.Is this any settings problem..? .Waiting for your reply.

Regards,
Bharath

Edited by: user12026039 on Jul 6, 2011 12:17 AM

This post has been answered by 670231 on Jul 6 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 3 2011

Added on Jul 6 2011

2 comments

929 views