Hi,
I want to make sequence as bigint or varchar(19) as below sequence don't help me what should i do to make it bigint.
Thanks
CREATE SEQUENCE AA_K
START WITH 1;
Oracle Database
Last Comment
Guy Hengel [angelIII / a3]
8/22/2022 - Mon
Guy Hengel [angelIII / a3]
oracle doesn't know "bigint". it knows NUMBER data type, and FLOAT ... for large numbers.
which is defined in the target column, not the sequence object http://www.techonthenet.com/oracle/sequences.php
with MAXVALUE 999999999999999999999999999 being the default, that should be big enough?
so you might want to clarify the question or actual problem?
sam2929
ASKER
what will be max value for below sequence?
CREATE SEQUENCE SEQ_D_DATE
START WITH 1
INCREMENT BY 1
NOCACHE
NOCYCLE;
which is defined in the target column, not the sequence object
http://www.techonthenet.com/oracle/sequences.php
with MAXVALUE 99999999999999999999999999
so you might want to clarify the question or actual problem?