Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tuning the DUAL table
good point :)
thnx.
On Thu, 20 Mar 2003 00:10:08 +0100, Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote:
>On Wed, 19 Mar 2003 22:25:16 GMT, andreyNSPAM_at_bookexchange.net
>(NetComrade) wrote:
>
>>we have a function that basicly does this:
>>(first name last name to lastname firstname)
>>
>>SELECT CONCAT(SUBSTR(:b1,0,(INSTR(:b1,',') + 2 )),'.')
>>FROM DUAL
>
>
>The select from dual is completely unnecessary in your example.
>A simple assignment would have done. Remove the select and you will
>loose the 5 gets.
>
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address
.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes
remove NSPAM to email
Received on Wed Mar 19 2003 - 17:56:54 CST