Home > user_source, user_views > USER_SOURCE — View the source SQL of your Procedure, Type in Oracle

USER_SOURCE — View the source SQL of your Procedure, Type in Oracle

July 14th, 2007 Arun Manivannan Leave a comment Go to comments

Yesterday i came across this particular system table USER_SOURCE.  Gives the source SQL for a variety of Oracle objects including Procedures and Types.  I dont have oracle installed in my home. So no screenshots.

You would have already known that USER_VIEWS table will give you the source select statement of a VIEW.

Categories: user_source, user_views Tags: ,
  1. No comments yet.
  1. No trackbacks yet.