Re: newbie question

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Wed, 23 Sep 1998 19:14:40 +0200
Message-ID: <36092C80.E63A9B44@psi.de>

Hello,

you will find all information in the Oracle data dictionary. For example the statement

SELECT * FROM USER_CONSTRAINTS will show information about the constraints for the actual user. To get the information in this way is not so comfortable. There are some tools. Try Hora 3 (http:\\www.keeptool.com for a free trial version).

regards Jan Dieckmann
Jan.Dieckmann_at_keeptool.com

John Nguyen wrote:

> hello gurus,
>
> I am somewhat new to Oracle and wonder if someone can tell me how I can
> go about finding what all the stored procedures and triggers are. And
> how to print them out etc.
>
> thanks
Received on Wed Sep 23 1998 - 12:14:40 CDT