oracle rename sequence

oracle rename sequence

                 

 oracle rename renames  sequence

 

SYNTAX:

Rename <old Name> to <new name>;

create a sequence emp_id_seq;
 SQL> create  sequence emp_id_seq;

renames emp_id_seqview to employee_id_seq;

 

SQL>rename emp_id_seq to employee_id_seq;

 

SQL> select * from employee_id_seq.nextval;

Tags:  rename sequence   in oracle,oracle rename sequence  , oracle rename syntax, oracle rename cons,oracle rename pros, How to rename sequence   in oracle,rename sequence   affect on triggers.