Creating a Sequence in Oracle

[joeythelips]

I am try to creata a sequence starting with a value from another table
CREATE SEQUENCE CALL_PRODUCT_SEQ
START WITH (SELECT CURR_VALUE FROM snap_counter where name ='AIB_CALL_PRODUCT_SEQ') INCREMENT BY 1

however it won't allow it, I have also tried to create the sequence starting with 1 and then try and increment using

alter sequence CALL_PRODUCT_SEQ increment by
(SELECT CURR_VALUE FROM snap_counter where name ='AIB_CALL_PRODUCT_SEQ')
this does'nt work either, has anyone any suggestions?

 

[r937]

could you do us a favour please?

post this question in one of the oracle forums

this forum is for ANSI SQL

thanks



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts July 10 2005)

 

[joeythelips]

sorry asbout that