OraFAQ Forum: SQL & PL/SQL » create a new sequence which should start with a value base on a column value

Home » SQL & PL/SQL » SQL & PL/SQL » create a new sequence which should start with a value base on a column value

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create a new sequence which should start with a value base on a column value [message #6801]

Tue, 06 May 2003 14:01

velappan
Messages: 2
Registered: May 2003

Junior Member

Hi,
I wanted to create a new sequence which should start with a value base on a column value in a table.
Any help is appreciated.

Thanks
velappan

Report message to a moderator

Re: create a new sequence which should start with a value base on a column value [message #6804 is a reply to message #6801]

Tue, 06 May 2003 17:52

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

declare
  v_value  t.id%type;
begin
  select nvl(max(id), 0) + 1
    into v_value
    from t;
 
  execute immediate 'create sequence myseq start with ' || v_value;
end;
/

Report message to a moderator

Previous Topic:	Oracle Forms text shifted to left
Next Topic:	Triggers - A Basic Question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 20 12:17:14 CDT 2026