Re: getting functions-source out of the databse
Date: Fri, 10 Jul 1998 23:27:52 -0700
Message-ID: <35A705E8.CCF09EB0_at_u.washington.edu>
The simplest is to use SQLplus. If you change the long length, the display will show more.
within sqlplus
set long 2000
select ...
You will be able to read longer fields.
Alternatively, get TOAD -- a shareware program, to read the functions.
(TOADSOFT.com
I think). TOAD is Tool for Oracle Application Development.
Alternatively, use the Oracle Administrator Tools -- one of the tools allows
you
to read all the table, views and function/procedures/packages. It is part of
the Oracle
installation on NT version of the server. I would think it is available on
other system.
It is typically NOT installed on machines to save space and improve
security. Ask
the DBA and/or locate the system disk.
Finally, SQL Navigator is an excellent tool -- with the ability to read any
function, etc.
It is a bit more $500 per seat, but if you are in a professional
environment, it will save
you more than that after a few weeks.
Mike Krolewski.
Gerben Scherpenzeel wrote:
> how can I get a list of functions, complete with the creation text, out
> of the Oracle Database? I know the information is stored in a view
> called ALL_SOURCE, but each line in a function definition is a record in
> this view. Is there an easy way of geting on line per function with the
> complete body of the function in it?
Received on Sat Jul 11 1998 - 08:27:52 CEST