I am trying to alter a sequence with the result of two subqueries. I am new with Oracle and stuck with a syntax. If you can, please help me with this : Upon Executing this, I am getting an “invalid number” error. What am I missing here? Answer You’ll definitely want PL/SQL and dynamic SQL, but don’t use LAST_NUMBER. Try