display Oracle function objects source code / SQL

  • From: Sven Aluoor <aluoor@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 21 Jun 2010 14:50:59 +0200

Hi folks

With this SQL statement I display all functions with their names

SQL> select object_name, status from user_objects
  2  where object_type = 'FUNCTION';

[...]

14 rows selected.

But how to show the source code / SQL of this functions?

(I did this with TOAD, but here I have no TOAD)

cheers
Sven
--
//www.freelists.org/webpage/oracle-l


Other related posts: