What is the USER_SOURCE data dictionary view?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the USER_SOURCE data dictionary view?
Rating:
The USER_SOURCE data dictionary view describes the source code (text source) of the stored objects owned by the current user. This view does not have the OWNER column. Following is the description of the columns of the USER_SOURCE data dictionary view:
| NAME | Name of the object |
| TYPE | Type of the object (e.g., PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, TRIGGER, etc.) |
| LINE | Line number of the source code |
| TEXT | Source code of the stored object |
Rating:
Was this information helpful?
Other articles
- What is the REMOTE_DEPENDENCIES_MODE parameter?
- What is trigger timing?
- What is the syntax for creating a package body?
- What is DBMS_JOB Oracle supplied package?
- What is PL/SQL?