Source code for backing up a package in Oracle

You need to specify the packagesSource codeBackup export:

Sets long 10240000
Spool c: \ package. SQL
Select text from all_source where ....
Spool off

 

-- Find the required package name

Select *
From all_objects t
Where T. object_type = 'package'
And owner = 'apps'
And trunc (T. last_ddl_time)> to_date ('2017-3-11 ', 'yyyy-MM-DD ')
And trunc (T. Created)> to_date ('2017-3-15 ', 'yyyy-MM-DD ')
Order by T. Created

 

-- Find the corresponding text based on the package name.

Select X .*
From all_source x
Where X. Owner = 'apps'
And exists
(Select 1
From all_objects t
Where T. object_type = 'package'
And owner = 'apps'
And trunc (T. last_ddl_time)> to_date ('2017-3-11 ', 'yyyy-MM-DD ')
And trunc (T. Created)> to_date ('2017-3-15 ', 'yyyy-MM-DD ')
And X. Name = T. object_name)

 

And then export it to the text.

20110926

View which packages or procedure references a table

Select X .*
From all_source x
Where instr (X. Text, 'table _ name')> 0