I think they look both the same, therefore, either should be just as fast,
but bear in mind, if you run proc.sql, then proc1.sql afterwards, it will
already be parsed, so proc1.sql will run marginally faster :)
(If they run at all :^) )
You would be much better off pasting the content of the procedures in to
your email Viktor, then the list may be able to help, I had noticed that you
have not tried any further due to no responses..
Regards
Mark
-----Original Message-----
Sent: Monday, February 12, 2001 04:13
To: Multiple recipients of list ORACLE-L
We've got some dynamic sql proc.
Attached are 2 files.
Which one you think should work faster?
Thanks.
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
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).
