Oracle Developer Tools for Visual Studio .NET
page 6 of 7
by Steven Swafford
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 33073/ 87

Working with Sequences

Creating a sequence is probably the simplest thing to do. By clicking New Sequence, the following window is displayed.

Figure 8: Creating a Sequence

The first step is to define the name of the sequence. In this case, I have a table named employees so it only makes sense to name the sequence seq_employees. While this is only a recommendation, you should use some sort of naming standard with your database objects. Next, define the type, values, and options of the sequence. If you are not sure what options to select, please refer to the following.

  • Allow cycle: Specifies whether the sequence generator will cycle back to MINVALUE from MAXVALUE when MAXVALUE is met. For sequences providing key values, it is probably not the best idea to cycle back.
  • Order values: This guarantees that sequence numbers are generated in order of the request.
  • Cache: The cache option specifies how many sequence values will be stored in memory for faster access. No cache means that none of the sequence values will be stored in memory.

View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2021  |  Page Processed at 2021-04-16 10:04:28 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search