Oracle’s SQL Engine is the underpinning of all Oracle Database applications. Oracle SQL continually evolves to meet the growing demands of increasingly more sophisticated database applications, and to enable emergent standards-based computing architectures, APIs, and network protocols. Oracle Dat

(Rastislav Ciganek) Here’s how to compile all invalid objects, including these with syntax errors. It can by used for specific schemas or for whole databases. In comparision with utlrp.sql you can: –specify the schema (user) in the statement “u.name” –see not just invalid objects, but al

Here are some more useful SQL tricks, tested on an Oracle database. Tips on building a test table and inserting values automatically, data types, insert/update with the check option and more.

(Marin Komadina) One block is soft corrupted when a block format is different from the Oracle default block format. Oracle soft data corruption (logical, software) is usually detected while reading some data from the disk to the database buffer cache. In the buffer cache, Oracle kernel investigate b

Here are some useful SQL tricks, tested on an Oracle database. The tips include information on derived tables, locking, working with random numbers, and more.

(Ajay Gursahani) This article gives a brief understanding about External tables. External Tables are defined as tables that do not reside in the database, and can be in any format for which an access driver is provided. This external table definition can be thought of as a view that allows running a

(Erika Morphy) In the first article in this two-part series, we took a look at what analysts and customers have identified as PeopleSoft CRM’s greatest weaknesses — a list that runs the gamut from poor navigation to a confusing approach to the company’s CRM philosophy. Now it is Oracle’s turn t

(Steve Callan) Where were you when Oracle9i was released? Okay, so it wasn’t that memorable of an event for most users, DBA’s, and the rest of the world. However, given that Oracle9i was released over two years ago, it is interesting to note that its new features are still being announced, highlight

This series of tutorials uses the Simple XML Based Content Management Application to demonstrate programming techniques that take advantage of the features of Oracle XML DB, a feature of Oracle 9i Database Release 2. The Oracle XML DB is fully compliant with the W3C XML data model thereby provid

(Steve Callan) Last month’s “Connecting with Oracle” article dealt with properly configuring the tnsnames.ora file. Using a statistics-related analogy for a minute, you can have Type I and Type II errors with respect to your tnsnames.ora file. You can have a “good” tnsnames.ora file, but “reject” it