(Steve Callan) In part 4 of the HTML DB series, I will cover the steps of upgrading to version 1.6 and creating a simple Web service. The upgrade/installation steps come straight out of the March 2005 Oracle HTML DB Installation Guide, Release 1.6. The steps to create a simple Web service are from t
Tag: Oracle
SQL and PL/SQL Features
(Arup Nanda) Encryption is a topic that evokes a mixed reaction in many users: interest coupled with a sense of wariness arising from the perceived complexity of key management, which can render the setup ineffective if not done correctly. There is also performance overhead associated with encryptin
Getting Cumulative Sum Using Oracle Analytical Functions
(Robert Ware) The following code is an alternative way to get a cumulative sum by using Oracle Analytical Function.
Oracle readies second grid database
(Martin LaMonica) The company said that Oracle 10g release 2 will build on the features in its existing edition, which it launched in February of last year. The database is designed to allow corporate customers to combine the processing muscle of several relatively inexpensive hardware servers, offe
Profitability Data Mart: Using Oracle 9i Windowing Functions in Cost of Funds and Interest Expense Calculation
(Radu Lovin) If you want to learn Excel the best way is to ask a finance person to teach you. They dream in Excel. If you ask them what they had for lunch, they quickly open an Excel sheet in their minds, put all the courses with all the ingredients and prices, draw a pivot table, apply a standard d
Security’s Starring Role in Oracle’s 10g DB
(Clint Boulton) Eighteen months after its grid computing Database 10g product took to the streets with a fervor, Oracle is pounding the pavement again with the second release of the software.
Fifteen things DBAs should unlearn about Oracle
Oracle 8i, 9i, and 10g have altered the facts behind several common practices followed by database administrators. Consultant and veteran DBA Bob Watkins suggests that ‘products move on,’ and the old way of doing things sometimes needs to be abandoned in favor of the methods that new features make p
Using PHP 5 with Oracle XML DB
(Yuli Vasiliev) As a programming language, PHP has many strengths, including ease of use, short development time, and high performance. With a brand-new object model, PHP 5 leverages the power and flexibility of object-oriented programming.
Using Clobs/Blobs with Oracle and Hibernate
Hibernate 1.2.1 comes with support for Clobs (and Blobs). Just use the clob type in your mapping file and java.sql.Clob in your persistent class.
Process Large Result Sets in Java Web Applications
(Srinivasa Rao Chintala) Many Web applications involve the processing of huge result sets, where you have to display a finite number of results per page for easier viewing across pages. Pagination is the most common way to handle large amounts of data in more manageable chunks — i.e., using PREVIOU
