In Oracle, you can create an autonumber field by using sequences. A sequence is an object in Oracle that is used to generate a number sequence. This can be useful when you need to create a unique number to act as a primary key.
Other News
Migrating from Access 2000 to SQL Server 2000
(Jayaram Krishnaswamy) In this article, we will simulate migrating a relatively small but established business from Microsoft Access 2000 to SQL Server 2000. There are a variety of reasons a business might wish to perform such a migration. Legacy queries, forms, and reports will be taken into consid
Ajax hype vs. reality
(Colleen Frye) “Less is more” when it comes to Ajax, a much-hyped Rich Internet Application (RIA) technology, according to Richard Monson-Haefel, a senior analyst at Burton Group Inc. in Midvale, Utah. The enabling technology can greatly enhance the user’s Web experience — rather than reloading pag
Use the .NET Framework to Generate and Execute Custom Controls at Run Time
(Morgan Skinner) One of the often overlooked features of the Microsoft .NET Framework is its ability to generate, compile, and execute custom code at run time. This is done, for example, during serialization of XML data, and in the use of regular expressions, where the expression evaluation function
Recovering an Oracle Database with Missing Archived Logs
(Terry Sutton) In this paper we will present a method for retrieving data from an Oracle database that cannot be opened normally because one or more datafiles is inconsistent with the others. An example of a scenario where you would find yourself in this situation is as follows: A disk failed on
Performing client-side XSL transformations
(Tony Marston) It is a feature of my software that I produce HTML output from XML documents with server-side XSL transformations. This means that as well as producing the XML document I transform it into HTML on the server before I send the result to the client.
Persisting PHP5 Objects in Oracle
(Barry McKay) Many developers have been won over by the elegance and efficiency of PHP5’s implementation of object-orientation, and are equally drawn to the power and robustness of the world’s foremost database, Oracle. However, taking the next logical step—storing PHP objects in your database for W
IBM Fields Entry-Level Content Management Solution
(Lee Kroon) IBM unveiled a new enterprise content management product for the iSeries that it will promote as an entry-level solution for small and medium-sized businesses. Since SMB firms are increasingly looking for solutions that can help them comply with information management regulations, the ne
Multithreading with the BackgroundWorker Component
(Paul Kimmel) .NET has tremendous support for asynchronous and multi-threaded programming. In previous versions, we had the Timer, asynchronous method invocation, the ThreadPool, and the Thread class. For lightweight processing parlour tricks, the Timer works fine. For lightweight asynchronous behav
Building a Better ASP.NET 1.1 BasePage Framework
(Chase Thomas) This is a journey on how to build a better Base page. The result of this will be a reusable framework that you can use to create as many Base pages as you like (on many different sites) and still have something that will keep the designers on your team happy. There is a lot to explain