(Lewis R Cunningham) This is a three-part definition of Oracle Security. Part 1 covers the various types of security Oracle provides. Part 2 deals with Users/Schemas, Roles, Permissions and Data Access. Part 2 will be a more technical discussion than parts 1 or 3. In part 3, I will discuss imple

A BEFORE INSERT Trigger means that Oracle will fire this trigger before the INSERT operation is executed.

When you perform a query on an Oracle database by using the ODBC CONVERT function, the Microsoft ODBC Driver for Oracle requests that the data be converted to DECIMAL for all ODBC integer types. DECIMAL is the default Oracle convert type. The following code is an example of this query: SELECT {fn

(Robin Schumacher) In the pursuit of optimal database performance, Oracle professionals have been slowly migrating away from performance analysis techniques that focused on blanket system ratios to a methodology that instead zeros in on where a system, application, or session is spending its time. R

(Terry Sutton and Roger Schrag) The wait event interface has continued to be an invaluable tool for DBAs as it offers both breadth and depth in the information it provides to aid in troubleshooting and boosting system performance. Throughout this paper we will assume the reader is familiar with

This white paper addresses the benefits and challenges of creating real-time collaborations with business partners. It discusses the technological barriers to success and how Oracle Application Server 10g is uniquely suited to providing a comprehensive integration solution, optimizing internal proce

(Andrei Cioroianu) JavaServer Faces (JSF) is a very useful standard framework (JSR-127) for Java developers because it defines an API and a basic set of tags for building Web-based user interfaces. Oracle Application Development Framework (ADF) Faces, based on the JSF framework, adds many new UI com

(Scott Stephens) Don’t be too quick to dismiss dynamic SQL used in PL/SQL programs. Scott Stephens provides code samples that demonstrate how using binds can help boost dynamic SQL performance.

(Steve Callan) Hidden away in the depths of your Oracle installation is a valuable resource you can use to get a jump-start on learning how to combine Oracle’s strength as a relational database management system and the power of the Internet. This resource is extremely easy to visit and requires

(Shawna McAlearney) Even as admins scrambled to patch numerous critical flaws in Oracle products today, some noted that fixes were unavailable for many other serious and well-known flaws — among them one in Oracle Forms detailed in a paper recently released. (R)