Re: Binary_code Oracle?

akelavlk wrote:

> I change my question. How can I see binary code of PL/SQL language in
> ORACLE database? Is it somewhere in system table or in file?

SELECT
  text
FROM all_source
WHERE owner = '<insert name>'
AND name = '<name of PL/SQL unit>'
AND TYPE = '<type of PL/SQL unit>'
ORDER BY line

The TYPE can be something like:

- 'FUNCTION'
- 'PROCEDURE'
- 'PACKAGE' 
- 'PACKAGE BODY' 

--
Billy