Oracle

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 e-book often addresses complicated themes in SQL with a spotlight on SQL features for Oracle 10g. The capabilities and techniques we conceal contain 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 moving information 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

Similar oracle books

Special Edition Using Oracle Applications

Exact variation utilizing Oracle functions is designed to be the main entire computer reference to be had. It contains particular well known issues equivalent to production and HR/Payroll functions. Implementation concepts and issues are lined for swift, pre-configured, phased, large bang, reengineered and customised implementation tasks.

Oracle Application Express 4.0 with Ext JS

Construct powerful, feature-rich internet functions utilizing Oracle APEX and Ext JS. upload extra refined parts and performance to an Oracle APEX software utilizing Ext JS. construct your individual topics in keeping with Ext JS into APEX - constructing templates for areas, labels, and lists. Create plug-ins on your program workspace to augment the present integrated performance of your APEX functions.

Oracle Database 12c PL-SQL programming

Grasp Oracle Database 12c PL/SQL program improvement improve, debug, and administer strong database courses. choked with particular examples and specialist suggestions from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains easy methods to retrieve and method information, write PL/SQL statements, execute potent queries, contain personal home page and Java, and paintings with dynamic SQL.

Extra info for Advanced SQL functions in Oracle 10g

Example text

If no how far amount is specified, then the rest of the string from the begin point is retrieved. If begin is negative, then retrieval occurs from the right-hand side of original string. ',1,12) FROM dual Which would give: SUBSTR('MYAD -----------My address i Here, the first 12 characters are returned from original string. The first 12 characters are specified since begin is 1 and how far is 12. Notice that blanks count as characters. ',5,12) From dual This would give: SUBSTR('MYAD -----------ddress is 12 In this case, the retrieval begins at position 5 and again goes for 12 characters.

If the spaces are not placed around 23 Common Oracle Functions: A Function Review “is”, then the “is” in “This” will be replaced along with the word “is”, as shown by the following query: SELECT REPLACE ('This is a test','is',' may be ') FROM dual This would give: REPLACE('THISISATEST','IS' -------------------------Th may be may be a test If the look for string is not present, then the replacing does not occur, as shown by the following query: SELECT REPLACE ('This is a test','glurg',' may be ') FROM dual Which would give: REPLACE('THISI -------------This is a test The TRIM Function TRIM is a function that removes characters from the left or right ends of a string or both ends.

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. If the INSTR pattern is not found, then the entire string would be returned, as shown by this query: SELECT SUBSTR('Harrison, John Edward', INSTR('Harrison, John Edward','zonk')) FROM dual This would give: SUBSTR('HARRISON,JOHN --------------------Harrison, John Edward 22 Chapter | 1 which is actually this: SELECT SUBSTR('Harrison, John Edward',0) FROM dual which would give: SUBSTR('HARRISON,JOHN --------------------Harrison, John Edward The REPLACE Function It is a common situation to not only find a pattern (INSTR) and perhaps extract it (SUBSTR), but then to replace the value(s) found.

Download PDF sample

Rated 4.26 of 5 – based on 35 votes