By Richard Walsh Earp, Sikha Saha Bagui

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

Сразу предупреждаю, что эта книга не расчитана на обучение языку SQL "с нуля". Предполагается, что читатель уже имеет опыт работы с Oracle, SQL*Plus и, в некоторых случаях, с PL/SQL. Основной упор в этой книге сделан именно на обучение новым возможностям Oracle 10g тех людей, которые перешли на "десятку" с более ранних версий. Вот что говорят о книге сами авторы:
This publication as a rule addresses complicated issues in SQL with a spotlight on SQL services for Oracle 10g. The features and strategies we disguise comprise the analytical features, version statements, commonplace expressions, and object-oriented/collection buildings. We additionally introduce and provides examples of the SQL/XML bridges as XML is a more moderen and customary approach to shifting facts from person to person. we depend seriously on examples, as such a lot SQL programmers can and do adapt examples to different difficulties quickly.

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

Show description

Read Online or Download Advanced SQL functions in Oracle 10g PDF

Similar oracle books

Oracle Database 11g Administrator Certified Professional Study Guide

Oracle Database 11g Administrator qualified expert learn consultant КНИГИ ; ОС и БД Название: Oracle Database 11g Administrator qualified expert research consultant Автор: Robert G. Freeman, Charles A. Pack Издательство: SYBEX ISBN: 0470395133 Год: 2009 Формат: PDF Размер: eight. ninety nine MB Страниц: 888 Язык: АнглийскийОписание книги: This up-to-date research advisor for the most recent liberate of the preferred database software program within the world—Oracle Database 11g— reports utilizing the RMAN restoration catalog, dealing with Flashback know-how, handling reminiscence and assets, automating initiatives, diagnosing the database, and lots more and plenty extra.

The CIO's Guide to Oracle Products and Solutions

From working platforms to the cloud, Oracle’s services and products are far and wide, and it has the marketplace proportion to end up it. Given the percentage range of the Oracle product line, and the extent of complexity of integration, administration could be very a frightening activity. The CIO's consultant to Oracle items and recommendations is the go-to advisor for all issues Oracle.

Oracle Identity Management

In today’s aggressive market with its specialise in revenue, protecting integrity can usually be a problem. additional complicating this problem is the truth that these assigned to the duty of assuring responsibility inside a firm usually have little, if any, visibility into the interior workings of that association.

Oracle Exadata Recipes A Problem-Solution Approach

Oracle Exadata Recipes takes an example-based, problem/solution method in exhibiting tips on how to dimension, set up, configure, deal with, display screen, optimize, and migrate Oracle database workloads on and to the Oracle Exadata Database computing device. no matter if you’re an Oracle Database administrator, Unix/Linux administrator, garage administrator, community administrator, or Oracle developer, Oracle Exadata Recipes offers powerful and confirmed ideas to complete a large choice of initiatives at the Exadata Database desktop.

Additional resources for Advanced SQL functions in Oracle 10g

Example text

COMPUTE allows us to calculate an aggregate value and place the result at the break point. The syntax of COMPUTE is: COMPUTE aggregate(column) ON break-point For example, if we wanted to sum the salaries and report the sums at the break points of the above query, we can execute the following script, which contains the COMPUTE command: SET echo off COLUMN curr_salary FORMAT $9,999,999 COLUMN ename FORMAT a10 COLUMN region FORMAT a6 45 Reporting Tools in Oracle’s SQL*Plus BREAK ON region skip1 COMPUTE sum of curr_salary ON region SET verify off SELECT empno, ename, curr_salary, region FROM employee ORDER BY region / CLEAR BREAKS CLEAR COMPUTES CLEAR COLUMNS SET verify on SET echo on Giving: EMPNO ---------108 111 122 101 106 102 104 ENAME CURR_SALARY REGION ---------- ----------- -----David $39,000 E Kate $49,000 Lindsey $52,000 ----------- ****** $140,000 sum John Chloe Stephanie Christina $39,000 W $44,000 $44,000 $55,000 ----------- ****** $182,000 sum Note the command for clearing BREAKs and COMPUTEs toward the end of the script after the SQL statement.

5 7 10 Note that a value of 10 has been included for lineno 7. But NVL does not change the actual data in the table. It only allows you to use some number in place of null 11 Common Oracle Functions: A Function Review in the SELECT statement (for example, if you are doing some calculations). Log and Exponential Functions SQL’s log and exponential functions include: LN — Returns natural logs, that is, logs with respect to base e. LOG — Returns base 10 log. EXP — Returns e raised to a value. POWER — Returns value raised to some exponential power.

07 To avoid having “naked” decimal points you could insert a zero in front of the decimal if the amount were less than one. 99” produces the same result, as the second zero is superfluous. We can also add dollar signs to the output. 07 Scripts Often, a formatting command is used but is meant for only one executable statement. ” is executed. To undo all column formatting, the command is: CLEAR COLUMNS A problem here may be that CLEAR COLUMNS clears all column formatting, but a universal CLEAR is likely appropriate as the AMOUNT column may well appear in some other table and one might not want the same formatting for both.

Download PDF sample

Rated 4.89 of 5 – based on 27 votes