Solved

Incremental fields in oracle

Posted on 2002-07-10
3
264 Views
Last Modified: 2010-04-04
Hello,

How can i create incremental fields in Oracle ,
Please  .. example ...

thank u
Asi
0
Comment
Question by:asi
3 Comments
 
LVL 2

Accepted Solution

by:
aubs earned 35 total points
ID: 7145864
If you mean like the autoinc field type of paradox/access
then the answer is that no such field type exists in Oracle.

You need to create a sequence and use the nextval and currval
properties of the sequence.



CREATE SEQUENCE MYSEQ;

INSERT INTO MYTABLE
(TAB_ID, CUSTOMER_NAME,...)
VALUES
(MYSEQ.NEXTVAL, 'Fred Bloggs',....)
0
 

Expert Comment

by:CleanupPing
ID: 9343078
asi:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
LVL 5

Expert Comment

by:Lukasz Lach
ID: 9460822
asi,
No comment has been added lately (18 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: Award points to aubs http:#7145864

Please leave any comments here within 7 days.

-- Please DO NOT accept this comment as an answer ! --

Thanks,

anAKiN
EE Cleanup Volunteer
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Delphi with SQL Natvie Client 15 86
indy tidtcpclient threading issue 8 63
Help on project with Soap 10 48
Press three keys together and trigger a function 3 51
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now