Re: A proper FAQ - Wish fulfillment

From: Pablo Sanchez <pablo_at_dev.null>
Date: Mon, 10 Mar 2003 15:01:23 -0600
Message-ID: <Xns933A8EA6FD202pingottpingottbah@216.166.71.233>

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in news:3e6ca15e$0$227$ed9e5944_at_reading.news.pipex.net:

> "Pablo Sanchez" <pablo_at_dev.null> wrote in message
> news:Xns933A463B9B830pingottpingottbah_at_216.166.71.233...

>> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in
>>
>> INSERT INTO t SELECT seq_t.nextval, 'hola!' FROM DUAL;

>
>
> Good point, and there is of course yet another version (which saves an
> infinitesimal amount of time)
>
> insert into t values(seq_t.nextval,'hola');

Good point! <g> ... my bad for poorly written code ...

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com

Received on Mon Mar 10 2003 - 15:01:23 CST