Advanced SQL functions in Oracle 10g by Richard Walsh Earp, Sikha Saha Bagui

By Richard Walsh Earp, Sikha Saha Bagui

Как известно, в Oracle 10g в репертуар инструкций языка SQL добавились новые возможности, делающие его ещё более мощным. Цель этой книги - самым доступным способом ознакомить программистов баз данных с этими новыми возможностями языка, чтобы они могли с успехом их применять в своей работе. Авторы снабдили каждую главу многочисленными работающими примерами для того, чтобы читатели могли сразу же опробовать новые возможности в процессе работы с книгой. Многие книги по Oracle 10g рассказывают только про синтаксис языка. В отличие от них, в этой книге кроме простого описания синтаксиса новых команд и функций авторы также дают совершенно ясное и детальное описание того, как эти функции работают и примеры как можно и нужно их использовать.

Сразу предупреждаю, что эта книга не расчитана на обучение языку SQL "с нуля". Предполагается, что читатель уже имеет опыт работы с Oracle, SQL*Plus и, в некоторых случаях, с PL/SQL. Основной упор в этой книге сделан именно на обучение новым возможностям Oracle 10g тех людей, которые перешли на "десятку" с более ранних версий. Вот что говорят о книге сами авторы:
This ebook almost always addresses complicated themes in SQL with a spotlight on SQL capabilities for Oracle 10g. The services and techniques we conceal contain the analytical capabilities, version statements, common expressions, and object-oriented/collection constructions. We additionally introduce and provides examples of the SQL/XML bridges as XML is a more moderen and customary approach to moving info from person to consumer. we depend seriously on examples, as so much SQL programmers can and do adapt examples to different difficulties quickly.

Насколько я знаю, книга на русский язык не переводилась.

Show description

Read or Download Advanced SQL functions in Oracle 10g PDF

Similar oracle books

Oracle Performance Tuning for 10gR2

Tuning of SQL code is mostly more cost-effective than altering the knowledge version. actual and configuration tuning contains a look for bottlenecks that regularly issues to SQL code or facts version concerns. development a suitable info version and writing accurately appearing SQL code can provide 100 percent+ functionality development.

Oracle Performance Survival Guide: A Systematic Approach to Database Optimization

Oracle functionality Survival advisor   a scientific method of Database Optimization   the short, whole, start-to-finish consultant to optimizing Oracle functionality   Oracle functionality Survival consultant deals a established, systematic, start-to-finish technique for optimizing Oracle functionality as successfully as attainable.

Oracle Internals: Tips, Tricks, and Techniques for DBAs

While you are a regular Oracle specialist, you do not have the posh of time to maintain with new know-how and browse the entire new manuals to appreciate every one new function of the most recent liberate from Oracle. you wish a entire resource of knowledge and in-depth information and methods for utilizing the recent expertise.

Oracle DBA on UNIX and Linux (Kaleidoscope)

Oracle DBA on Unix and Linux offers the entire info had to set up, help, music, and improve Oracle databases at the UNIX and Linux structures. preserve a powerful, mission-critical Oracle8i database. This booklet presents administrative suggestions for the daily DBA. you are going to the best way to set up the database for optimum potency, improvements, patches, migrations, track, and hold its defense.

Extra resources for Advanced SQL functions in Oracle 10g

Sample text

2903226 Here we explicitly converted our character string dates to date data types before applying the MONTHS_ BETWEEN function. ): SELECT NEXT_DAY(TO_DATE('15SEP2006','DDMONYYYY'),'Monday') FROM dual This gives: NEXT_DAY( --------18-SEP-06 The Monday after 15-SEP-06 is 18-SEP-06, which is displayed in the default date format. 30 Chapter | 2 Chapter 2 Reporting Tools in Oracle’s SQL*Plus The purpose of this chapter is to present some illustrations that will move us to common ground when using the reporting tools of Oracle’s SQL*Plus.

For example, if we format the empno field to make it shorter, we can use: COLUMN empno FORMAT 999 and type: SELECT empno, ename FROM employee which gives this result: EMPNO ----101 102 104 108 111 106 122 ENAME ---------John Stephanie Christina David Kate Chloe Lindsey 35 Reporting Tools in Oracle’s SQL*Plus With numbers, if the format size is less than the heading size, then the field width defaults to be the heading size. This is the case with empno, which is 5. 00 Numbers can also be output with leading zeros or dollar signs if desired.

42 Format Will look like dd Month yyyy 05 March 2006 dd month YY 05 march 06 dd Mon 05 Mar dd RM yyyy 05 III 2003 Chapter | Format Will look like Day Mon yyyy Sunday Mar 2006 Day fmMonth dd, yyyy Sunday March 5, 2006 Mon ddsp yyyy Mar five 2006 ddMon yy hh24:mi:ss 05Mar 06 00:00:00 2 BREAK Often when looking at a result set it is convenient to “break” the report on some column to produce easyto-read output. Consider the Employee table result set like this (with columns formatted): SELECT empno, ename, curr_salary, region FROM employee ORDER BY region Giving: EMPNO ----108 111 122 101 106 102 104 ENAME CURR_SALARY REGION ---------- ----------- -----David 39,000 E Kate 49,000 E Lindsey 52,000 E John 39,000 W Chloe 44,000 W Stephanie 44,000 W Christina 55,000 W Now, if we execute the command: BREAK ON region the output is formatted to look like the following, where the regions are displayed once and the output is arranged by region: 43 Reporting Tools in Oracle’s SQL*Plus EMPNO ----108 111 122 101 106 102 104 ENAME CURR_SALARY REGION ---------- ----------- -----David 39,000 E Kate 49,000 Lindsey 52,000 John 39,000 W Chloe 44,000 Stephanie 44,000 Christina 55,000 If a blank line is desired between the regions, we can enhance the BREAK command with a skip like this: BREAK ON region skip1 to produce: EMPNO ----108 111 122 101 106 102 104 ENAME CURR_SALARY REGION ---------- ----------- -----David 39,000 E Kate 49,000 Lindsey 52,000 John Chloe Stephanie Christina 39,000 W 44,000 44,000 55,000 It is very important to note that the query contains an ORDER BY clause that mirrors the BREAK command.

Download PDF sample

Rated 4.14 of 5 – based on 11 votes