By Richard Walsh Earp, Sikha Saha Bagui

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

Сразу предупреждаю, что эта книга не расчитана на обучение языку SQL "с нуля". Предполагается, что читатель уже имеет опыт работы с Oracle, SQL*Plus и, в некоторых случаях, с PL/SQL. Основной упор в этой книге сделан именно на обучение новым возможностям Oracle 10g тех людей, которые перешли на "десятку" с более ранних версий. Вот что говорят о книге сами авторы:
This publication usually addresses complicated issues in SQL with a spotlight on SQL services for Oracle 10g. The services and strategies we hide contain the analytical capabilities, version statements, common expressions, and object-oriented/collection buildings. We additionally introduce and provides examples of the SQL/XML bridges as XML is a more recent and customary approach to moving information 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 E-Business Suite Financials R12: A Functionality Guide

Oracle EBS Financials supply businesses with options to quite a lot of lengthy- and non permanent accounting approach concerns. Oracle E-Business Suite is the main accomplished suite of built-in, international enterprise purposes that offers the main whole, built-in company intelligence portfolio

Oracle E-Business Suite: A performance advisor – is helping in binding the 2 ability units jointly – wisdom of the software program and the enterprise wisdom of the user.

This advisor comprises every little thing you want to understand to maximise your implementation payback or go back on investment.

This booklet begins with an summary of Oracle E-Business Suite R12 the place we conceal the root positive factors of Oracle monetary administration modules which come with Navigation inside of Oracle E-Business Suite free up 12, a number of association entry keep watch over (MOAC), key points of program safeguard and lots more and plenty extra. The e-book then covers intimately normal Ledger, Sub Ledger Accounting, resources, money administration, Treasury, E-Business Tax, and masses extra.

Oracle PL/SQL For DBAs

PL/SQL, Oracle's robust procedural language, has been the cornerstone of Oracle program improvement for almost 15 years. even if basically a device for builders, PL/SQL has additionally turn into a vital device for database management, as DBAs take expanding accountability for website functionality and because the strains among builders and DBAs blur.

Oracle 9i. Database Performance Guide and Reference

This ebook describes special how one can improve Oracle functionality via writing and tuning SQL thoroughly utilizing functionality instruments, and optimizing example functionality. Ii additionally explains the right way to create an preliminary database for stable functionality and comprises performance-related reference info.

Extra info for Advanced SQL functions in Oracle 10g

Sample text

This is the case with empno, which is 5. 00 Numbers can also be output with leading zeros or dollar signs if desired. 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.

COS — Returns the cosine of a value. TAN — Returns the tangent of a value. 1416 / 360) To illustrate the use of the ordinary trigonometric functions, let’s suppose we have a table called Trig with the following description: DESC trig Will give: Name Null? 577351902 Hyperbolic Trig Functions SQL’s hyperbolic trigonometric functions include: SINH — Returns the hyperbolic sine of a value. COSH — Returns the hyperbolic cosine of a value. TANH — Returns the hyperbolic tangent of a value. 48047372 In terms of usage, the common numerical manipulation functions (ABS, MOD, SIGN, SQRT), the “near value” functions (CEIL, FLOOR, ROUND, TRUNC), and NVL (an Oracle exclusive null handling function) are used often.

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

Download Advanced SQL functions in Oracle 10g by Richard Walsh Earp, Sikha Saha Bagui PDF
Rated 4.67 of 5 – based on 14 votes