Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "The table hier_balanced is a balanced hierarchy and the table hier_ragged is a ragged hierarchy".

A block of code is set as follows:

select hier, count(*) from (
SELECT LPAD(' ', level*2, ' ') || col2 as hier
FROM hier_ragged
START WITH col1 = 'Root'
CONNECT BY PRIOR col2 = col1)
group by hier
having count(*) > 1;

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "View Connection Information, and click on Edit ...