Oracle Database Data Dictionary Text source of the stored objects
Example
USER_SOURCE describes the text source of the stored objects owned by the current user. This view does not display the OWNER column.
select * from user_source where type='TRIGGER' and lower(text) like '%order%'
ALL_SOURCE describes the text source of the stored objects accessible to the current user.
select * from all_source where owner=:owner
DBA_SOURCE describes the text source of all stored objects in the database.
select * from dba_source
