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 often addresses complex themes in SQL with a spotlight on SQL features for Oracle 10g. The capabilities and strategies we hide comprise the analytical services, version statements, normal 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 moving information 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

Expert Oracle Practices: Oracle Database Administration from the Oak Table

This publication is an anthology of potent database administration suggestions representing the collective knowledge of the OakTable community. With an emphasis upon performance—but additionally branching into protection, nationwide language, and different issues—the e-book is helping you carry the main price in your company’s funding in Oracle Database applied sciences. You’ll discover ways to successfully plan for and video display functionality, to troubleshoot systematically whilst issues get it wrong, and to control your database instead of letting it deal with you.
* undertake a rational method of database administration; do away with guesswork
* upload worth in your association as a database expert
* deal with and optimize functionality
* make the most assorted platform applied sciences
* safe your organization's information
* achieve deep knowing of database internals and buildings
<h3>Who is that this booklet for? </h3>
This publication is aimed toward Oracle database directors who are looking to extra their careers through imposing sound and confirmed database management practices—and specially repeatable and predictable practices—in their day-by-day work.

Pro Oracle SQL (Expert's Voice in Oracle)

Seasoned Oracle SQL unlocks the ability of SQL within the Oracle Database—one of the main effective SQL implementations out there at the present time. To grasp it calls for a three-pronged technique: examine the language beneficial properties, examine the aiding gains that Oracle offers to assist use the language successfully, and discover ways to imagine and paintings in units.

Combined Analysis

This publication introduces and information the main elements of mixed research - an x-ray and/or neutron scattering method which mixes structural, textural, pressure, microstructural, part, layer, or different suitable variable or estate analyses in one process. The textual content starts off with uncomplicated theories on the topic of diffraction by means of polycrystals and a few of the most typical mixed research instrumental set-ups are targeted.

Additional info for Advanced SQL functions in Oracle 10g

Example text

Here we present and discuss these string functions. ” The INSTR Function INSTR (“in-string”) is a function used to find patterns in strings. By patterns we mean a series of alphanumeric characters. The general syntax of INSTR is: INSTR (string to search, search pattern [, start [, occurrence]]) The arguments within brackets ([]) are optional. We will illustrate each argument with examples. INSTR returns a location within the string where search pattern begins. Here are some examples of the use of the INSTR function: SELECT INSTR(‘This is a test’,’is’) FROM dual This will give: INSTR('THISISATEST','IS') ------------------------3 18 Chapter | 1 The first character of string to search is numbered 1.

Txt from the SQL> command line. An even better script would contain some SET commands to control feature values. 99 SET verify off SELECT empno, amount FROM coffee_fund; CLEAR COLUMNS SET verify on SET echo on The “echo” feature displays the command on the screen when executed. To make the script run cleanly, you should routinely turn echo and verify off at the beginning of the script and turn them back on at the end of the script. 40 Chapter | 2 Other feature values that may be manipulated in this way are “pagesize,” which defaults to 24 and may be insufficient for a particular query, and “feedback,” which shows how many records were selected if it exceeds a certain amount.

Trim character may be any character. The word FROM is necessary only if where or trim character is present. Here is an example: SELECT TRIM (' This string has leading and trailing spaces ') FROM dual Which gives: TRIM('THISSTRINGHASLEADINGANDTRAILINGSPACES ------------------------------------------This string has leading and trailing spaces Both the leading and trailing spaces are deleted. This is probably the most common use of the function. We can be more explicit in the use of the function, as shown in the following query: SELECT TRIM (both ' ' from ' FROM dual String with blanks ') Which gives: TRIM(BOTH''FROM'ST -----------------String with blanks In these examples, characters rather than spaces are trimmed: SELECT TRIM('F' from 'Frogs prefer deep water') FROM dual Which would give: TRIM('F'FROM'FROGSPREF ---------------------rogs prefer deep water 25 Common Oracle Functions: A Function Review Here are some other examples.

Download PDF sample

Rated 4.40 of 5 – based on 28 votes