Advanced SQL functions in Oracle 10g - download pdf or read online

By Richard Walsh Earp, Sikha Saha Bagui

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

Сразу предупреждаю, что эта книга не расчитана на обучение языку SQL "с нуля". Предполагается, что читатель уже имеет опыт работы с Oracle, SQL*Plus и, в некоторых случаях, с PL/SQL. Основной упор в этой книге сделан именно на обучение новым возможностям Oracle 10g тех людей, которые перешли на "десятку" с более ранних версий. Вот что говорят о книге сами авторы:
This booklet regularly addresses complex issues in SQL with a spotlight on SQL services for Oracle 10g. The capabilities and strategies we disguise comprise the analytical features, version statements, typical 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 shifting facts from consumer 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

Read e-book online Oracle Service Bus 11g Development Cookbook PDF

* boost carrier and message-oriented ideas at the Oracle carrier Bus following top practices utilizing this e-book and ebook

* expand your functional wisdom of creating suggestions at the Oracle carrier Bus

* full of hands-on cookbook recipes, with the total and comprehensive answer as an OSB and SOA Suite undertaking, made on hand electronically for download

Download e-book for iPad: Oracle General Ledger Guide by Melanie Cameron

Grasp Oracle E-Business Suite's Oracle common Ledger retain a centralized, hugely automatic processing platform across a absolutely built-in set of Oracle E-Business Suite functions utilizing Oracle common Ledger. This Oracle Press consultant explains find out how to make the most of Oracle common Ledger to distribute well timed and exact monetary info enterprise-wide.

Oracle Exadata Recipes A Problem-Solution Approach - download pdf or read online

Oracle Exadata Recipes takes an example-based, problem/solution method in exhibiting how you can dimension, set up, configure, deal with, display screen, optimize, and migrate Oracle database workloads on and to the Oracle Exadata Database desktop. even if you’re an Oracle Database administrator, Unix/Linux administrator, garage administrator, community administrator, or Oracle developer, Oracle Exadata Recipes presents powerful and confirmed suggestions to complete a large choice of projects at the Exadata Database laptop.

Tushar Thakker's Pro Oracle Fusion Applications: Installation and PDF

Seasoned Oracle Fusion functions is your one-stop resource for aid with fitting Oracle's Fusion functions suite on your on-premise atmosphere. It additionally aids within the tracking and ongoing management of your Fusion surroundings. writer Tushar Thakker is celebrated for his writings and services on Oracle Fusion functions, and now he brings his gathered knowledge to you within the kind of this handy instruction manual.

Additional resources for Advanced SQL functions in Oracle 10g

Example text

This chapter should bridge the gap between a general knowledge of SQL and Oracle’s SQL*Plus, the operating environment under which SQL runs. Earlier versions of Oracle contained some formatting functions that could have been used to produce some of the results that we illustrate in this book. In their own right, these reporting functions are quite useful and provide a way to format outputs (result sets) conveniently. Therefore, before we begin exploring “late Oracle” functions, we illustrate some of Oracle’s more popular reporting tools.

The first argument is the base of the log, and the second argument is the number that you want to take the log of. In the following example, we are taking the log of 2, base value. 4242151 Example 4: Using the POWER function: The POWER function requires two arguments. The first argument is the value that you would like raised to some exponential power, and the second argument is the power (exponent) that you would like the number raised to. See the following example: 13 Common Oracle Functions: A Function Review SELECT POWER(value,2) FROM function_illustrator WHERE lineno = 0 Which gives: POWER(VALUE,2) -------------81 Ordinary Trigonometry Functions SQL’s ordinary trigonometry functions include: SIN — Returns the sine of a value.

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. 35583515 Example 2: Using the LOG function: The LOG function requires two arguments.

Download PDF sample

Rated 4.64 of 5 – based on 9 votes