Link to home
Start Free TrialLog in
Avatar of sam2929
sam2929

asked on

making sequence bigint

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;
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

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?
Avatar of sam2929
sam2929

ASKER

what will be max value for below sequence?

CREATE SEQUENCE  SEQ_D_DATE
START WITH     1
INCREMENT BY   1
NOCACHE
NOCYCLE;
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial