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
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