ISBN 10: 0-9776715-8-5 ISBN 13: 978-0-9776715-8-8 Library of Congress Number: 2008937201 300 pages Perfect bind - 9x7 PD 1208 Shelving: Databases/Oracle Oracle In-focus Series #28

Advanced Oracle SQL Programming The Expert Guide to Writing Complex Queries Laurent Schneider, Oracle ACE, Oracle Certified Master Retail Price $49.95 / £24.95 Order now at 30% off and get access to the code depot! Only $34.95 (30% off) Key Features About the Author Table of Contents Index Errata

About the Author:

Laurent Schneider

Laurent Schneider is one of the most respected authors in Oracle technology, with many years of experience as a Systems Engineer and Database Engineer. Laurent achieved the highest level of DBA certification in 2004, being the first Oracle Certified Master in Switzerland and recipient of the prestigious Oracle Technology Network ACE trophy. Laurent has over a decade of expertise in development - specializing in data warehousing and database modeling as well as database administration. He currently works for a successful Swiss bank as application architect/developer. In his spare time, Laurent enjoys studying Chinese Chess strategy and has won the Swiss Championship. He lives on the sunny side of the Uetliberg with his wife Bertille, his daughter Dora and his son Loïc.

Table of Contents:

Index:

[ [[:alpha:]] A ABS ALL AND antijoin ANY APPENDCHILDXML ASC ASCIISTR AUTOTRACE AVG B BEGINTIME BETWEEN BFILE BFILENAME BIN_TO_NUM BINARY_DOUBLE BINARY_FLOAT BITAND BLOB C CASE CAST CC CEIL CHAR CHR CLOB COALESCE CONCAT CONNECT BY CONNECT_BY_IS_LEAF CONNECT_BY_ISCYCLE CONNECT_BY_ROOT correlated subquery COUNT COUNT DISTINCT COUNT(*) CROSS JOIN CUBE CURRENT ROW CV D D DATE DAY dbms_rowid DD DECODE DELETEXML DENSE_RANK DESC DIMENSION DISTINCT DUAL E ENAME ENDTIME equijoin EVALNAME EXCLUDE NULLS execution plan EXISTS EXISTSNODE EXTRACT EXTRACTVALUE F FAST DUAL FF FIRST_VALUE FLOOR FM FOLLOWING FOR loops FROM full outer join function-based indexes G GREATEST greedy expression GROUP BY GROUP_ID GROUPING GROUPING SETS H hash join HASH JOIN FULL OUTER HAVING HEXTORAW HH HH24 HOUR I IGNORE NULLS IN INCLUDE NULLS INITCAP inline view INSERTCHILDXML INSERTXMLBEFORE INSTR INSTR2 INSTR4 INSTRB INTERSECT IS ANY IS PRESENT ITERATE ITERATION_NUMBER IW

J J join JOIN K KEEP L LAG LAST_VALUE LEAD LEAST LENGTH LENGTH2 LENGTH4 LENGTHB LENGTHC LEVEL LNNVL LOWER LPAD LTRIM M materialized views MAX MEASURES MI MINUS MINUTE MM MOD MODEL modulo MONTH N NATURAL JOIN NCHR nested subquery NLS_CHARSET_ID NLS_DATE_TERRITORY NLS_INITCAP NLS_LOWER NLS_SORT NLS_TERRITORY NLS_UPPER NOCYCLE non-greedy expression NOT EXISTS NOT IN NOT NULL NULL NULLIF NUMBER NUMTODSINTERVAL NUMTOYMINTERVAL NVL NVL2 O OBJECT_VALUE OCCURRENCE ON ora:view Oracle Calendar Oracle Locale Builder ORDER BY ORDER SIBLINGS BY outer join OVER P PARTITION PARTITION BY partition key partition views partitioned outer join PERIODBEGIN PIVOT PIVOT XML POSIX PRECEDING PRIOR pseudo column Q Q R RANGE RANGE BETWEEN RANGE CURRENT ROW RANK RATIO_TO_REPORT RAW RAWTOHEX REF CURSOR REGEXP_COUNT REGEXP_INSTR REGEXP_LIKE REGEXP_REPLACE REGEXP_SUBSTR REMAINDER REPLACE RM ROLLUP ROUND ROW_NUMBER ROWNUM ROWS ROWS BETWEEN ROWS CURRENT ROW RPAD RR RTRIM RULES UPDATES

S scalar subquery SECOND SELECT semijoin session-independent views SIBLINGS SIGN SINGLE REFERENCE single-row subquery SOME SORT GROUP BY SORT UNIQUE SP SQL Spreadsheet SSSSS START WITH STATS_MODE STOPKEY subquery factoring SUBSTR SUBSTR2 SUBSTR4 SUBSTRB SUBSTRC SUM SYS_CONNECT_BY_PATH SYS_GUID T TERMOUT OFF TERMOUT ON TH TIMESTAMP TO_BINARY_DOUBLE TO_BINARY_FLOAT TO_BLOB TO_CHAR TO_CLOB TO_DATE TO_DSINTERVAL TO_NCHAR TO_NCLOB TO_NUMBER TO_TIMESTAMP TO_TIMESTAMP_TZ TO_YMINTERVAL TRANSLATE TRIM TRUNC U UNBOUNDED FOLLOWING UNBOUNDED PRECEDING UNION UNION ALL UNION-ALL PARTITION UNIQUE UNIQUE DIMENSION UNIQUE SINGLE REFERENCE UNISTR UNPIVOT UNTIL UPDATE UPDATEXML UPPER UPSERT UPSERT ALL USING V V VARCHAR2 53, VSIZE W W WHERE WITH WW X XMLAGG XMLCAST XMLCONCAT XMLELEMENT XMLEXISTS XMLFOREST XMLQUERY XMLSEQUENCE XMLSERIALIZE XMLTYPE XPATH XQuery XQUERY Y Y YEAR YY

Errata:

p227: conclusion: the main keywords in building a hierarchy are STAND BY, PRIOR and START WITH,

the main keywords in building a hierarchy are CONNECT BY, PRIOR and START WITH,

The diagrams in pages 237 and 238 require correction. ANALY-ST is cut, same as 1-9-8-1, 1-9-8-0 and 198-1.