Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments
COURSE of the MONTH
15 days, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
making sequence bigint
Posted on 2013-01-01
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;
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;
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
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 99999999999999999999999999
so you might want to clarify the question or actual problem?
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?
what will be max value for below sequence?
CREATE SEQUENCE SEQ_D_DATE
START WITH 1
INCREMENT BY 1
NOCACHE
NOCYCLE;
CREATE SEQUENCE SEQ_D_DATE
START WITH 1
INCREMENT BY 1
NOCACHE
NOCYCLE;
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
How to Unravel a Tricky Query
Introduction
If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them. …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
- Acronis
- Databases
- Oracle Database
- MongoDB
- Oracle
- *Backup Software
This video shows how to Export data from an Oracle database using the Datapump Export Utility. The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month15 days, 14 hours left to enroll
743 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.