SQL & PL/SQL

Hi All,

I would like to create a sequence number in oracle but instead of hard coding the "start with" I want to select the max value of the primary key of a table and add 1 and use this instead:

So what I want is:

CREATE SEQUENCE crg_mrec_seq
MINVALUE 1
MAXVALUE 999999999999999999999999999
START WITH select max(primarykey)+1 from table1
INCREMENT BY 1
CACHE 20;

I'm guessing I need to pass this max value as a variable into the create sequence number but I'm not sure what syntax to use.

Thanks,
Ed