(Ana Hernandez) Many IT organizations require that email notifications (including email-to-page notifications) be sent to the appropriate administrators when an alert is detected. This Technical Note describes a best-practice methodology for setting this process up in the Enterprise Manager (EM) 10g

(Jonathan Gennick) Routine tasks are boring. If you perform them manually, you wind up doing the same task over and over, with the risk that one day you might slip up and skip a step or make some other mistake. Oracle Database 10g’s new built-in job scheduler gives you powerful capabilities for

This step-by-step article describes how to set up a linked server from a Microsoft SQL Server computer to an Oracle database and also provides basic troubleshooting steps for common errors you may encounter when you set up a linked server to Oracle.

(Sanjay Mishra and Alan Beaulieu) There are situations when we need to combine the results from two or more SELECTstatements. SQL enables us to handle these requirements by using set operations. The result of each SELECT statement can be treated as a set, and SQL set operations can be applied on th

The Internet, by nature is called the World-Wide-Web because it addresses a global market. Internet applications have the infrastructure and capability to support users with different language and cultural requirements. A truly global Internet application needs to support data exchange in a wid

(Steve Muench) BC4J provides automatic facilities for deploying any application module as a stateful EJB session bean. If you want to leverage the features of your BC4J application module from a stateless EJB session bean, it’s not automatic but it is straightforward to implement. This howto article

(Emmett Dulaney) Underlying every conditional statement is a test to see what is true and what is not. Knowing how this works can make the difference between writing mediocre scripts and ones you’ll be proud of. The all too often underappreciated shell script is limited in power only by the abil

(Steve Callan) If someone asked me what learning Oracle performance tuning is like initially, I would have to say the title of this article aptly describes the process. Moreover, to make matters worse, it is not even one pool, but several pools in which the novice tuner can drown. Knowing what defin

(John Kirkley) With the millions of Web applications that have been developed over the years, it seems logical that the industry would have found a standards-based way to deal with the many graphical user interface (GUI) and presentation issues associated with them.

If you need to internationalize your business by adding support for more countries and languages to your Oracle J2EE business applications; or you already support an international operation but would like to consolidate to one application and Oracle database and manage everything from one central p