Daily Roundup of News, Tips and Tricks for 2010-02-06
-
Problems once again wracked Oracle's new My Oracle Support portal this week, with some users reporting difficulties accessing the site.
-
Recursive database processing, also called the bill of materials or parts explosion problem, is applicable to many application domains including human resources, manufacturing, financial markets, and academia. Data involved in such processing are referred to as tree structured or hierarchical. Oracle Database has long supported recursion through a proprietary syntax, the CONNECT BY clause. Oracle Database 11g Release 2 supports recursion through subquery factoring resulting in a new and potentially better way to deal with an old problem: querying hierarchical data.
-
This article takes a step by step approach to create a table with a nested table and then query that table while showing some key DBA views we can use to describe the structures.
-
This post demonstrates by way of examples, some of the most common XPath expressions.
-
This web-site is where Andrew Barry, an Oracle DBA, keeps some of the scripts and procedures that he's written over the years.
-
This book offers detailed instructions for installing, configuring, and effectively using Oracle SQL Developer. You will learn how to utilize every feature of this development tool and make the most out of it. While none of the tasks are complex, the book progresses from the easy, most commonly used features, such as browsing objects and writing queries in the SQL Worksheet, to the more involved and possibly less frequently used features, such as Tuning and Testing SQL and PL/SQL, and adding User Extensions, and finally to those features used by a smaller more targeted audience, such as Migrations, Oracle APEX, and the Data Modeler. Throughout the book there are tips and suggestions gathered as a result of working with the current SQL Developer user base. This book will also show you how to assess the health of your database with built-in as well as customized reports.
Related articles:
- Mini Posts Roundup from Twitterland (2007-04-08)
- Mini Posts Roundup from Twitterland (2007-07-24)
- Mini Posts Roundup from Twitterland (2007-07-30)