Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    7

    Angry Unanswered: Unable to view full VIEW definition

    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

  2. #2
    Join Date
    May 2003
    Location
    Dublin, Ireland
    Posts
    44

    Re: Unable to view full VIEW definition

    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.

    Originally posted by naag007
    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

  3. #3
    Join Date
    Jun 2003
    Posts
    7
    Thanks a lot..sjacek. Now I am able to view it fully

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •