Sequence generator in Oracle

Sequence generator in Oracle - Sequence generator in Oracle...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Sequence generator in Oracle For this exercise, lets create animals table. Create table animals ( animalID1 Number, animalID2 Number, animalID3 Number, animalID4 Number, name varchar (15) ); What is an Oracle sequence? - Its a database object that enables to generate unique integer values. What is a purpose of creating a sequence? Can use a sequence to generate the unique primary key values. SequenceName is the name of the sequence to be created. Increment by specifies an interval between the generated numbers. An interval can be either positive or negative integer, but cannot be 0. If the interval is negative, the sequence values are descending. If you dont specify the increment value, its 1 by default. Start with specifies the initial value. If you dont specify the starting value, its 0 by default. Z and w are the maximum and minimum possible values. the starting value, its 0 by default....
View Full Document

This note was uploaded on 12/22/2009 for the course DBST DBST 651 taught by Professor Yelena - ta during the Spring '09 term at MD University College.

Page1 / 5

Sequence generator in Oracle - Sequence generator in Oracle...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online