Query to get object (Function) definition - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Query to get object (Function) definition

  1. #11
    Join Date
    Jul 2000
    Posts
    521
    Use USER_SOURCE or DBA_SOURCE if you do not see USER_PROCEDURES.
    svk

  2. #12
    Join Date
    Jul 2003
    Posts
    136
    Dba_Source and User_Source views
    was what I was looking for. Thanks Tomcat & Dave23uk.

    I should have mentioned oracle version (8.1.7) but thought that this was such a generic question.

    Anyway user_procedures view in 10g will not show us definition, so we need User_Source or dba_source to get the object defintion.

    Thanks again
    -D

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