Recent content by Jack Canoy

I think I've found a way to do this... VARIABLE inc NUMBER SELECT sequence_name NAME, last_number NEXT FROM user_sequences WHERE sequence_name = 'DTR_TEST'; begin select dtr_Test.nextval into :inc from dual; execute immediate 'alter sequence dtr_Test increment by ' | | -:inc | |...

This works in SQLPLUS, but I can't seem to get it to work in a Command window... it fails at 3rd statement "-&inc". If not possible in Developer, is there a way to do similar (store a variable from a SELECT)? Thanks column S new_val inc; select Meter_s.nextval S from dual; alter sequence...