Обсуждение: how to insert from sequence

Поиск
Список
Период
Сортировка

how to insert from sequence

От
soundar rajan
Дата:
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