Re: Function much slower than same statement.

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 7 Jul 2003 23:21:40 -0700
Message-ID: <1de5ebe7.0307072221.6a19f6d2@posting.google.com>

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:<3F09928D.2F7_at_yahoo.com>...
>
> You need a space:
>
> select /*+ORDERED*/ works in SQL but not PLSQL
>
> select /*+ ORDERED */ works in both
>
> hth
> connor

Thank you so much, Connor. I knew there was a space issue, but I was not sure if I shoud place a space or not, and when It worked in sqlplus without spaces I inferred (wrong!) that this was the right way, so I didn't try the other (stupid!!). I will never forget again.

Greetings from Spain. Received on Tue Jul 08 2003 - 01:21:40 CDT