(Umesh Kulkarni) This tip explains the steps required to set up an Oracle JDBC Connection from an applet and subsequently perform JDBC operations using the JDBC connection.

(Ravi Nookala) This tip is useful in locating the index name for a corresponding primary key constraint. It displays the details of the primary key along with the corresponding index name for a given owner and tablename. This script has been tested on 7x, 8x and 9x, and works on versions 8x or highe

(Robyn Lorusso) How much do you know about Oracle9i Web development? We challenge you to test your skills by taking our first Know-IT-all Chapter Quiz. Share the results with us and get a chance to win a copy of “Oracle9i Web development” by Bradley Brown, courtesy of McGraw-Hill. (R)

(Jason Price) As we’ve all learned by now, the web services model has proven to be an efficient way to connect applications. Web services protocols such as XML, the de facto standard for information interchange; SOAP (Simple Object Access Protocol), which allows you to exchange XML documents in a di

Backup and recovery is one of the most important aspects of database administration. If a database crashed and there was no way to recover it, the devastating results to a business could include lost data, lost revenue and customer dissatisfaction. Whether companies operate a single database or mult

(Marco Gilbert) Here is a function to get the next “D” day in Oracle Database.

You may have noticed that the default value for the db_block_checksum parameter is TRUE in Oracle 9i and above, whereas it was FALSE in previous versions. Although this makes it much less likely that minor data corruptions will go unnoticed, there is also a performance cost of which you should be aw

(Kimberly Floss) The word “automatic” seems to have been liberally applied to a raft of new features in Oracle Database 10g—Automatic Database Diagnostic Monitor (ADDM); Automatic Workload Repository (AWR); automatic space management, and automatic SQL tuning, for instance. However, before you think

(Edmund X. DeJesus) Oracle recommends immediate patching to fix multiple vulnerabilities in the Oracle Web Cache. Oracle declined to provide details, but failure to fix the problems could allow malicious remote exploitation. (R)

(Steve Callan) In this continuing series of installation cookbooks, we will look at a new and improved version of Oracle’s Application Server. This standalone release of Application Server, identified by “10g (9.0.4),” enables you to deploy forms (and reports) over the web without the overhead of in