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 booklet generally addresses complicated subject matters in SQL with a spotlight on SQL services for Oracle 10g. The capabilities and techniques we hide contain the analytical capabilities, version statements, general 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 facts from person to consumer. 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 Real Application Clusters Guard. Administration and Reference Guide

This record is meant for database directors and method directors who have to administer an Oracle actual program Clusters shield atmosphere. they're assumed to have an intensive realizing of the recommendations of Oracle genuine software Clusters shield, the management of the Oracle server and OracIe 9i genuine software Clusters, and their platform-specific cluster know-how

SQL Server 7 Backup and Recovery

SQL Server 7 Backup & restoration is your one-stop source for making plans, constructing, enforcing, and dealing with backup and fix strategies.

Expert Oracle JDBC Programming: High Performance Applications with Oracle 10g

This hugely expected ebook tackles functionality concerns in JDBC functions head-on, that will help you turn into knowledgeable your self! The publication information concisely and obviously, the correct points of Oracle's structure that at once influence the functionality and effectiveness of your JDBC software. writer R.

Oracle Application Server Portal Handbook

The final word Oracle software Server Portal ResourceBuild dynamic, feature-rich company portals utilizing Oracle software Server Portal and the professional info during this particular Oracle Press consultant. you will how you can maximize the functions of Oracle software Server Portal, customise your portals, combine Oracle varieties and Oracle reviews, and upload Java performance.

Additional info for Advanced SQL functions in Oracle 10g

Sample text

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.

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. As we suggested in the introduction, some knowledge of SQL is assumed before we begin. This chapter should bridge the gap between a general knowledge of SQL and Oracle’s SQL*Plus, the operating environment under which SQL runs.

If a fourth argument is desired, then the third argument is mandatory. If search pattern is not in the string, the INSTR function returns 0, as shown by the query below: SELECT INSTR('This is a test','abc',1,2) FROM dual Which would give: INSTR('THISISATEST','ABC',1,2) -----------------------------0 19 Common Oracle Functions: A Function Review The SUBSTR Function The SUBSTR function returns part of a string. The general syntax of the function is as follows: SUBSTR(original string, begin [,how far]) An original string is to be dissected beginning at the begin character.

Download PDF sample

Rated 4.14 of 5 – based on 28 votes