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
Other News
Pros and Cons of Defining Tablespaces as Locksize Row In DB2
This article explains how defining tablespaces with Locksize Row can impact your DB2 implementation. Find out about several different responses to this request for help in determing the best set of options to use with DB2.
Compile all invalid objects including those with syntax errors
(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
SQL Server security tips, part 2
(Robert Westervelt)From a security standpoint, dynamic SQL creates the opportunity for SQL Injection. SQL Injection allows hackers to embed additional SQL statements into the statement that the user is to run. When code is assembled dynamically, either in an application or in a stored procedure, the
How to Obtain Case-Sensitive Query Results with a Case-Insensitive Sort Order
A sort order is a set of rules that determines how SQL Server collates and presents data in response to database queries. The sort order determines the order in which data is presented in response to SQL Server statements involving GROUP BY, ORDER BY, and DISTINCT clauses. The sort order also determ
Oracle SQL tricks 2
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.
Tip: Implement XMLReader
(Benoit Marchal) In this tip, Benoit Marchal explores APIs for XML pipelines. He concludes that the familiar XMLReader interface is appropriate for many XML components. One of the most popular designs for processing XML documents is the pipeline. A pipeline is a group of components where each com
Basic Performance Tuning, Part 2
(Roger Sanders) How to change your instance and database parameters for the best Performance effect. If you read the first installment of this Distribued DBA column in the Quarter 3, 2003 issue, you know that database performance problems typically arise from one of the following factors: –Sy
The Threat from Below
(Michael Otey) SQL Server is too expensive. At least that’s what more and more readers—many of whom are looking at the free MySQL or other lower cost open-source databases—have told me over the past year. With SQL Server 2000, Microsoft introduced a per-processor licensing model, increasing the p
Uniquely Trigger Happy
(Dave Hauser) Trying to get around the 255-byte index key limit without sacrificing uniqueness? Triggers just might save the day. If you’ve ever had to adapt schemas from other platforms — such as DB2 Universal Database (DB2 UDB) for NT — to DB2 UDB for z/OS and OS/390 you’ve probably bumped up a