Re: Using sequence in WebDB?

Hello,

You could use the sequence from some PL/SQLin the ".. after processing form" section of a form that modifies the table where you need the increasing

ID number;

declare
begin
  update schema.tablename
  set seqno = to_char(xxx_seq.nextval, 'FM9999999999')     where IDfield = 'unassigned';
end;

Marc
mao_at_dde.dk

Johannes Nurmi wrote:

> I am using Oracle WebDB and come up with following problem (and I did not
> find any help from help files).
> I need automatically increasing number for my ID field.
> I heard that it should be done with sequence.
> I can create one, but how to link it to work with that table?
>
> TIA, Johannes Nurmi
Received on Fri Jul 23 1999 - 10:57:30 CEST