Re: Tuning the DUAL table

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Thu, 20 Mar 2003 00:10:08 +0100
Message-ID: <15uh7v80ffiio8gn694jc0io753k7fvl6r@4ax.com>

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 Received on Wed Mar 19 2003 - 17:10:08 CST