How can I declare a local variable in a SQLPLUS script.
Here is what I want to do:
DECLARE @value NUMBER (38);
SET @value = SELECT MAX(COLUMNNAME) from Some_TABLE;
CREATE SEQUENCE SOMESEQ START WITH @value + '1' INCREMENT BY 1
However, these statements do not work in SQLPlus. Can someone help me out with it?