DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: determine full text of sql statement

  1. #1
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322

    determine full text of sql statement

    i m using oracle 10g. How can i find the complete text of an sql statement?

    V$SQLTEXT has this output..

    SQL> desc v$sqltext
    Name Null? Type
    ----------------------------------------------- -------- --------------------------------
    ADDRESS RAW(8)
    HASH_VALUE NUMBER
    SQL_ID VARCHAR2(13)
    COMMAND_TYPE NUMBER
    PIECE NUMBER
    SQL_TEXT VARCHAR2(64)

    i have also checked out v$sql and v$sqlarea...both have sql_text field's length varchar2(1000)
    lucky

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool Many pieces

    Each SQL statement in V$SQLTEXT has MANY pieces...It's all there.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

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


Click Here to Expand Forum to Full Width