Oracle databases display some differences in Server Explorer. For example, when you add a connection to an Oracle database, you will see these folders: Database Diagrams, Tables, Synonyms, Views, Stored Procedures, Functions, Package Specifications, and Package Bodies. The following topics briefly d

(Steven Feuerstein) I have been writing PL/SQL code since 1990. This means I have churned out tens of thousands of lines of software, and most of it, I am certain, was poorly written and difficult to maintain. Fortunately, I have discovered that it is never too late to find—and follow—new paths

A new feature of Oracle Database 10g vastly improves your ability to search and manipulate character data. (Alice Rischert) This feature, regular expressions, is a notation for describing textual patterns. It has long been available in many programming languages and a number of UNIX utilities. O

(Philip Greenspun) From version 9 onwards it is possible to represent points in time and time intervals using ANSI SQL data types such as timestamp and interval. We strongly recommend that you use the newly available ANSI data types when building new applications. Visit the main chapter on dates for

A potential security vulnerability has been discovered in the Oracle Files component that ships with Oracle Collaboration Suite Release 1. A knowledgeable and malicious user of Oracle Files can potentially access restricted content. In the Oracle Files component that ships with Oracle Collaborat

(Virag Saksena) The readers will learn about contention for different resources in the server – latches, locks and ST enqueues. They will learn to determine if contention for any of these resources is responsible for performance problems. They will learn to drill down to identify the sessions causi

Oracle Enterprise Manager is a system management tool which provides an integrated solution for managing your heterogeneous environment. It combines a graphical console, agents, common services, and tools to provide an integrated, comprehensive systems management platform for managing Oracle product

(Sean Hull) Oracle is a powerful database for building web-based applications. PHP is famous for being quick and efficient; it can help you build fast applications that are not going to weigh down your database. Pair Oracle up with PHP, and you get a powerhouse combination. PHP (an acronym for P

Oracle Corp. has announced plans to incorporate grid-computing techniques and standards across its product line in the forthcoming Oracle 10g release. According to Robert Shimp, Oracle vice president of database marketing, “grid computing will be every bit as significant as the Internet” in its impo

(Jonathan Gennick) Recently I wrote about Oracle’s support for hierarchical queries in an OTN article titled Querying Hierarchies: Top-of-the-Line Support. While writing that article, I learned about some exciting, new features in Oracle Database 10g that strengthen Oracle’s already robust support f