Skip to content
November 9, 2016 / doganay

LINE NUMBERS OF STORED OBJECTS

SELECT owner,
       name,
       DECODE (TYPE, 'PACKAGE BODY', 'PACKAGE', TYPE),
       SUM (max_line)
  FROM (SELECT owner,
               name,
               TYPE,
               MAX (line) max_line
          FROM dba_source
         WHERE owner NOT IN (SELECT owner
                               FROM dba_logstdby_skip
                              WHERE statement_opt = 'INTERNAL SCHEMA')
        GROUP BY owner, name, TYPE)
GROUP BY owner, name, DECODE (TYPE, 'PACKAGE BODY', 'PACKAGE', TYPE)
ORDER BY 4 DESC
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: