I am trying to create a sequence that starts from the max id in my table.
I went off this previously asked question How to create sequence using starting value from query?
This is the sequence:
CREATE SEQUENCE q9_seq; SELECT setval('q9_seq', (SELECT MAX(department_id) FROM hr_departments));
The result im getting is :
ORA-00923: FROM keyword not found where expected error.