Oracle requires using cursors with SELECT statements, regardless of the number of rows requested from the database. In Microsoft® SQL Server™, a SELECT statement that is not disclosed on a cursor returns rows to the client as a default result set. This is an efficient way to return data to a client

(Kelli Wiseth) XML has become a key technology throughout the enterprise in Web services, business-process management (BPM), enterprise-application integration (EAI), and numerous other initiatives. As a result, Java developers can expect XML to play an increasingly important role in development pro

(Dave Aldridge) One feature that is almost ubiquitous in Oracle data warehousing is the use of the Partitioning Option. Over the past few major releases the feature set associated with partitioning has increased to cover four different partitioning types and improvements in the manageability of part

(Chris Schalk) You may be surprised to find out that JDeveloper 10g actually contains the widely popular JavaServer Pages Standard Tag Library (JSTL). This means that it is possible to use JSTL directly out of the box within JDeveloper without requiring you to download JSTL separately and install in

(Cheryl Ross) After years of balking about porting its database to the AS/400, Oracle has finally made it to the platform. The company has launched a developer’s release of Oracle 9.2.04 for IBM’s PowerPC chip that runs on SuSE Linux on the iSeries or pSeries. For years, OS/400 has been overlooked b

(Jeff Spicer) System downtime is expensive—very expensive, depending on your business. In some industries when a critical system or application fails or is taken offline, the cost can run millions of dollars per hour—and that’s just in lost sales or transactions and doesn’t take into account damage

(Dave Aldridge) Some of the major differences from OLTP systems that you will encounter in data warehousing are the types of tables. The Oracle Data Warehousing Guide names and describes two major table types – facts, and dimensions, and if you were not sure of the difference, it would be worthwh

(Lisa Vaas) Oracle Corp. last week revealed that a potential security vulnerability has been discovered in its Oracle9i Application Server and Oracle9i Database Server.

(Srinivas Kasam) This example shows how to find how many times a day of the week comes between two dates.

A stored procedure is a named group of SQL statements that have been previously created and stored in the server database. Stored procedures accept input parameters so that a single procedure can be used over the network by several clients using different input data. Stored procedures reduce network