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

By Richard Walsh Earp, Sikha Saha Bagui

ISBN-10: 818333184X

ISBN-13: 9788183331845

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

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

New PDF release: JRuby Rails Web Application Development

This SpringerBrief explains the right way to create a Rails internet program with JRuby, a a hundred% Java implementation for Ruby. This short demonstrates how Oracle® WebLogic servers and JBoss® program servers install the JRuby software, how JRuby runs at the Java® digital computing device, and the way JRuby is the root for well known web pages together with LinkedIn, Oracle combine, and Mingle.

Download e-book for iPad: Mastering Oracle SQL and SQL*Plus by Lex deHaan

SQL is the ANSI-standard language for getting access to and manipulating relational databases. an individual (programmers, directors, or designers) who paintings with a relational databases have to comprehend the SQL language. whereas so much books out there don't thoroughly disguise the fundamentals, this ebook differs: it explains basics intimately, supported by means of real looking examples.

Oracle Business Intelligence: The Condensed Guide to by Yuli Vasiliev PDF

This ebook is a short consultant to getting begun with Oracle enterprise Intelligence SE platform that may solution universal enterprise questions and assist you make fast enterprise judgements. The examples during this publication can assist you arrange the database for research and create company stories very quickly. when you are an enterprise analyst, a document builder, a DBA, or an program developer who desires to the way to use the Oracle enterprise Intelligence platform for research and reporting, this can be the correct e-book for you.

Download PDF by Y V Ravikumar, K M Krishnakumar, Nassyam Basha: Oracle Database Upgrade and Migration Methods: Including

So it’s time to improve Oracle Database to model 12c and also you have to select the correct approach whereas contemplating matters corresponding to downtime. This booklet explains the entire to be had improve and migration equipment so that you can select the person who fits your atmosphere. you'll be conscious of the sensible matters and proactive measures to take to improve effectively and decrease unforeseen concerns.

Additional resources for Advanced SQL functions in Oracle 10g

Sample text

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.

Harrison, John Edward,” and wanted to retrieve first and middle names, we could use the comma and space to find the end of the last name. ” The begin number has been replaced by the INSTR function, which returns the position of the comma and blank space. Since INSTR is using two characters to find the place to begin retrieval, the actual retrieval must begin two characters to the right of that point. If we do not move over two spaces, then we get this: SELECT SUBSTR('Harrison, John Edward', INSTR('Harrison, John Edward',', ')) FROM dual This would give: SUBSTR('HARRI ------------, John Edward The result includes the comma and space because retrieval starts where the INSTR function indicated the position of search pattern occurred.

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. An engineer or scientist might use the LOG, POWER, and trig functions. 17 Common Oracle Functions: A Function Review String Functions A host of string functions are available in Oracle.

Download PDF sample

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

by Jason

Rated 4.53 of 5 – based on 8 votes

About admin