Learn how to retrieve rows set by set from an Oracle database without getting previously obtained rows in subsequent sets. Boris Milrud demonstrates how to use packages as holders for session-persistent data.
DSN less connections don’t require creation of system level DSNs for connecting to databases and provide an alternative to DSNs. We will now see how to connect to a database via ASP using Connection String in place of DSN name.
By Wylie Wong – Oracle Chief Executive Larry Ellison on Wednesday said the database giant will meet Wall Street estimates for its fourth-quarter earnings, ending speculation that the company might have to announce a profit warning this week.
By Tore Bostrup – This is the first of a two-part article that will provide an introduction to relational databases and the SQL language. This first part describes some of the key elements of the technology with an emphasis on database normalization. The second part will describe a less theoretical
By Alexander Chigrik – As a SQL Server DBA, I often need a reference to information about locks. Microsoft recommends using the sp_lock system stored procedure to report locks information. This very useful procedure returns the information about SQL Server process ID, which lock the data, about loc
By Andrew Georgopulos – The first step in my initiation as a SQL Server admin came after only a week or two on the job. I was confronted with a message that made my palms sweat. The error read something like this:
Three OASIS Committee Specifications, Directory Services Markup Language (DSML) v2, ebXML Registry Service (RS) v2, and ebXML Registry Information Model (RIM) v2, have passed final approval by the OASIS membership at-large to gain official status as OASIS Standards. To reach this milestone, each of
By Shane Curcuru – As the use of schemas grows, the need for tools to manipulate schemas grows. The new Schema Infoset Model provides a complete modeling of schemas themselves, including the concrete representations as well as the abstract relationships within a schema or a set of schemas. This arti
by Steven Livingstone – In this article we will look at the latest XML parser from Microsoft, MSXML 4.0. Microsoft has taken a lot of criticism in the past over its adoption of non-standard schema and XSL drafts, which happened most often in early parser releases and even version 3.0 to a lesser ext
By Mike Ricciuti – Oracle on Wednesday boosted its support for the Linux operating system with a new version of its database software. The software maker said that it has developed a version of its 9i database software that can run across multiple Linux servers in a configuration called clust