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

By Richard Walsh Earp, Sikha Saha Bagui

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

Сразу предупреждаю, что эта книга не расчитана на обучение языку SQL "с нуля". Предполагается, что читатель уже имеет опыт работы с Oracle, SQL*Plus и, в некоторых случаях, с PL/SQL. Основной упор в этой книге сделан именно на обучение новым возможностям Oracle 10g тех людей, которые перешли на "десятку" с более ранних версий. Вот что говорят о книге сами авторы:
This e-book ordinarily addresses complex subject matters in SQL with a spotlight on SQL services for Oracle 10g. The features and techniques we hide comprise 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 recent and customary approach to moving facts from person to person. 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

Best oracle books

High-Performance Oracle: Proven Methods for Achieving Optimum Performance and Availability

"Geoff Ingram has met the problem of proposing the advanced means of coping with Oracle functionality. This e-book can help each technical individual seeking to unravel Oracle8i and Oracle9i functionality matters. -Aki Ratner, President, special software program SolutionsEnsuring high-performance and non-stop availability of Oracle software program is a key concentration of database managers.

Oracle Database 10g New Features

This booklet offers a superb evaluate of the adjustments in Oracle 10g. It doesn't drill down into element, that's left for different courses, yet is a simple place to begin for a DBA emigrate from past types of Oracle. The e-book is straightforward to learn and the diagrams are transparent and upload to the textual content.

Beginning Oracle PL/SQL

Starting Oracle PL/SQL will get you all started in utilizing the integrated language that each Oracle developer and database administrator needs to be aware of. Oracle Database is brim-full of integrated software gains which are loose for the utilizing, and PL/SQL is your price ticket to studying approximately and utilizing these gains out of your personal code.

Applying and extending Oracle Spatial

This publication is a complicated useful advisor to making use of and increasing Oracle Spatial. This e-book is for latest clients of Oracle and Oracle Spatial who've, at a minimal, easy operational adventure of utilizing Oracle or an identical database. complex abilities usually are not required

Extra resources for Advanced SQL functions in Oracle 10g

Example text

Example 1: SELECT TRIM(leading 'F' from 'Frogs prefer deep water') FROM dual Which would give: TRIM(LEADING'F'FROM'FR ---------------------rogs prefer deep water Example 2: SELECT TRIM(trailing 'r' from 'Frogs prefer deep water') FROM dual Which would give: TRIM(TRAILING'R'FROM'F ---------------------Frogs prefer deep wate Example 3: SELECT TRIM (both 'z' from 'zzzzz I am asleep zzzzzz') FROM dual Which would give: TRIM(BOTH'Z'F ------------I am asleep In the last example, note that the blank space was preserved because it was not trimmed.

We must format dates to see all of the information contained in a date. , convert to a character string) is full of possibilities. ) Here is an example: SELECT TO_CHAR(SYSDATE, 'dd Mon, yyyy hh24:mi:ss') FROM dual 27 Common Oracle Functions: A Function Review This gives: TO_CHAR(SYSDATE,'DDMO --------------------10 Sep, 2006 14:04:59 This presentation gives us not only the date in “dd Mon yyyy” format, but also gives us the time in 24-hour hours, minutes, and seconds. We can add months to any date with the ADD_ MONTHS function like this: SELECT TO_CHAR(SYSDATE, 'ddMONyyyy') Today, TO_CHAR(ADD_MONTHS(SYSDATE, 3), 'ddMONyyyy') "+ 3 mon", TO_CHAR(ADD_MONTHS(SYSDATE, -23), 'ddMONyyyy') "- 23 mon" FROM dual This will give us: TODAY + 3 mon - 23 mon --------- --------- --------10SEP2006 10DEC2006 10OCT2004 In this example, note that the ADD_MONTHS function is applied to SYSDATE, a date data type, and then the result is converted to a character string with TO_CHAR.

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. , greater than 999), then octothorpes (#) would be displayed in the output. A better way to use formatting is to put the format and the statement in a script.

Download PDF sample

Rated 4.31 of 5 – based on 32 votes