Thread: how to insert from sequence

how to insert from sequence

From
soundar rajan
Date:
Hi all,

I need help in inserting a value from sequence.  My
code goes like this (from Java).  I do face a syntax
level problem.

statement.execute("insert into T_name (id) values (" +
nextval('s_name') + ")");

Thanks in advance for the help.


__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com

Re: [GENERAL] how to insert from sequence

From
Shadkam Islam
Date:
Try

 statement.execute("insert into T_name (id) values (nextval('s_name'))");

Regards,
Shad.

On Wed, 27 Oct 1999, soundar rajan wrote:

> Hi all,
>
> I need help in inserting a value from sequence.  My
> code goes like this (from Java).  I do face a syntax
> level problem.
>
> statement.execute("insert into T_name (id) values (" +
> nextval('s_name') + ")");
>
> Thanks in advance for the help.
>
>
> __________________________________________________
> Do You Yahoo!?
> Bid and sell for free at http://auctions.yahoo.com
>
> ************
>