15일차 # 3-14: USER_SOURCE data dictionary

select distinct type

from user_source;

TYPE

------------

PROCEDURE

PACKAGE BODY

PACKAGE

FUNCTION

select name, line, text

from user_source

where type = 'PACKAGE'

union all

select name, line, text

from user_source

where type = 'PACKAGE BODY';