Hi,

I want to see text definition for a view defined in my schema. When I queried like this I am getting only 80 chars from definition. How to view it fully?? (Oracle version 8.1.7)

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

TEXT
--------------------------------------------------------------------------------
select task_id, carrying_out_organization_id, service_type_code, project_id, tas

thanks in advance
Raju

Use 'set long nnn' sqlplus command to specify length of the output (nnn characters).
As a default Oracle uses 80 for LONG fields thats why your text gets truncated.

Thanks a lot..sjacek. Now I am able to view it fully