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