Alone as an Island What’s the pride in being a Programmer?
Jul 14

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

user_source, user_views Add 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.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • bodytext
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • De.lirio.us
  • description
  • Furl
  • Reddit
  • Slashdot
  • Spurl
  • StumbleUpon
  • Technorati
  • TwitThis

Tags: ,

Leave a Reply

Give your best to the world.