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 complex issues in SQL with a spotlight on SQL features for Oracle 10g. The capabilities and techniques we conceal contain the analytical services, version statements, average 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 info from consumer 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

Best oracle books

OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)

A completely built-in research method for OCA examination 1Z0-052

Prepare for the Oracle qualified affiliate Oracle Database 11g management I examination with aid from this specific Oracle Press consultant. In every one bankruptcy, you'll locate demanding workouts, perform questions, a two-minute drill, and a bankruptcy precis to spotlight what you've realized. This authoritative advisor may help you move the try out and function your crucial on-the-job reference. Get entire insurance of all OCA ambitions for examination 1Z0-052, including:

Database structure
developing an Oracle Database
coping with the Oracle example
Configuring and coping with the Oracle community
dealing with database garage buildings
Administering consumer safety
dealing with schema gadgets, info and concurrency, and undo info
enforcing Oracle Database protection
Database upkeep and function administration
Backup and restoration
relocating info
clever infrastructure improvements

JD Edwards EnterpriseOne, The Complete Reference

Your definitive advisor to JD Edwards EnterpriseOneImplement and keep a completely built-in, SOA-based ERP framework throughout all your company. JD Edwards EnterpriseOne: the entire Reference explains how you can set up and administer JD Edwards EnterpriseOne, shop BI info in info marts and warehouses, deal with servers and portals, and improve custom-made purposes and kernel approaches.

The Oracle Universal Content Management Handbook

This booklet employs the method of "you and me talking", which makes studying easy and enjoyable. .. even addictive! it truly is packed with particular examples, shortcuts, and ready-to-use ideas. you will prove with a operating, ready-to-use Oracle UCM method by way of the top of bankruptcy 2. and you'll bounce chapters and browse them in any order that greater matches your ardour or your project to hand.

Oracle database 12c security

Top Practices for finished Oracle Database safeguard Written through well known specialists from Oracle's nationwide safeguard crew, Oracle Database 12c defense presents confirmed suggestions for designing, imposing, and certifying safe Oracle Database platforms in a multitenant structure. The ideas also are acceptable to standalone databases.

Additional info for Advanced SQL functions in Oracle 10g

Example text

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. , greater than 999), then octothorpes (#) would be displayed in the output. A better way to use formatting is to put the format and the statement in a script. /bin directory (Windows) and run with a START command.

We can add months to any date with the ADD_ MONTHS function like this: SELECT TO_CHAR(SYSDATE, 'ddMONyyyy') Today, TO_CHAR(ADD_MONTHS(SYSDATE, 3), 'ddMONyyyy') "+ 3 mon", TO_CHAR(ADD_MONTHS(SYSDATE, -23), 'ddMONyyyy') "- 23 mon" FROM dual This will give us: TODAY + 3 mon - 23 mon --------- --------- --------10SEP2006 10DEC2006 10OCT2004 In this example, note that the ADD_MONTHS function is applied to SYSDATE, a date data type, and then the result is converted to a character string with TO_CHAR.

But NVL does not change the actual data in the table. 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.14 of 5 – based on 30 votes