Re: Re[7]: to_number question

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 21 Jul 2004 20:55:08 +0100
Message-ID: <010f01c46f5c$9feb5150$7102a8c0@Primary>

Someone has just posted an interesting link on c.d.o.server which is about PL/SQL optimisation, but makes interesting reading in the light of this thread:

 http://otn.oracle.com/tech/pl_sql/files/CodeOrder.zip

In particular, the "freedom":

    The SQL standard offers a freedom which is finding use in the Oracle Database 10g

    PL/SQL compiler. If there is a way to evaluate an operation and to provide a

    "correct" result even though some other method of evaluation might raise an

    exception, then the exception need not be raised.

This sounds very similar to Dan Tow's comment (I may have credited this incorrectly) about Oracle 'suspending judgement' because one predicate fails, and then deciding that it does not need to raise an exception because another predicate makes the first error irrelevant.

Regards
Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated July 20th

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Jul 21 2004 - 14:53:02 CDT