Lee,
Thanks for your advise, for me this question is just kick off to the world
of ORACLE PL/SQL scripting,
I don't know why you think that I would like to ask from a Great and full of
experiance DBA like you Mr. Lee to spoon feeding me.
Again Thank You so much for your advise
Xing,
-----Original Message-----
Lee Robertson
Sent: Thursday, 29 March 2001 3:16 PM
To: Multiple recipients of list ORACLE-L
Xing,
Have a look at the documentation, specifically, Application Developers
Guide, section dealing with "Using Procedures and Packages".
No disrespect intended but sometimes, certainly for questions such as this,
you will learn a heck of a lot more by digging around in the docs, and
reading (and working out) the answer for yourself. That is certainly my
experience. You will also fell encouraged to delve further and learn more
about other packages etc. Hope my pointer will help you.
To the rest of you - I know it would have been quicker to write down the
answer to Xings question, but what will he have learned about the general
syntax ??
Regards
Lee
-----Original Message-----
Sent: 29 March 2001 07:05
To: Multiple recipients of list ORACLE-L
Hi DBAs and SAs,
Can someone tell me what is this ORACLE PL/SQL Script all about,..
Ya... I know I have to read alot, my OCP course will start next month.
BEGIN
dbms_utility.analyze_schema ( '&OWNER', 'ESTIMATE', NULL, 5 ) ;
END ;
/
Thank you
Xing
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: lerobe - Lee Robertson
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
