Re: What syntax better (faster,cool)!

From: <pcucciolo_at_hotmail.com>
Date: Mon, 07 Dec 1998 16:02:43 GMT
Message-ID: <74gu71$ngm$1@nnrp1.dejanews.com>

When you execute the open cursor, you exec the select .... Can you use the select only if you are sure the select return 1 value else too many rows is the exception to capture.

In article <74g64v$393$1_at_nnrp1.dejanews.com>, sokol_at_opsb.ru wrote:
>
>
> select COL into VAR from TABLE;
>
> or
>
> open CURSOR;
> fetch COL into VAR;
> close CURSOR;
>
> Tanks.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 07 1998 - 10:02:43 CST