Home » SQL & PL/SQL » SQL & PL/SQL » create a new sequence which should start with a value base on a column value
create a new sequence which should start with a value base on a column value [message #6801] Tue, 06 May 2003 14:01 Go to next message
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
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 Go to previous message
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;
/
Previous Topic: Oracle Forms text shifted to left
Next Topic: Triggers - A Basic Question
Goto Forum:
  


Current Time: Thu Mar 28 03:22:02 CDT 2024