One thought on “Oracle: source text for the view, package and other objects

  1. select text from OBJECT_SOURCE where owner = ‘SCHEMA_OWNER’ and name = ‘OBJECT_NAME’;

    When we use this query, we are getting text in grid format, how to get the data in text format?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.