Create a Sequence with START WITH from Query

Viewed 32669

How can I create a Sequence where my START WITH value comes from a query?

I'm trying this way: CREATE SEQUENCE "Seq" INCREMENT BY 1 START WITH (SELECT MAX("ID") FROM "Table");

But, I get the ORA-01722 error

2 Answers
Related