• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

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;
0
sam2929
Asked:
sam2929
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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?
0
 
sam2929Author Commented:
what will be max value for below sequence?

CREATE SEQUENCE  SEQ_D_DATE
START WITH     1
INCREMENT BY   1
NOCACHE
NOCYCLE;
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
as documented in above link, and written in above comment:
MAXVALUE 999999999999999999999999999 being the default ...
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now