making sequence bigint

sam2929
sam2929 used Ask the Experts™
on
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;
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented:
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?

Author

Commented:
what will be max value for below sequence?

CREATE SEQUENCE  SEQ_D_DATE
START WITH     1
INCREMENT BY   1
NOCACHE
NOCYCLE;
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
as documented in above link, and written in above comment:
MAXVALUE 999999999999999999999999999 being the default ...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial