東華大學圖書館 |

Modern Oracle Database programming = level up your skill set to Oracle's latest and most powerful features in sql, pl/sql, and json /

紀錄類型:	書目-電子資源 : Monograph/item
正題名/作者:	Modern Oracle Database programming/ by Alex Nuijten, Patrick Barel.
其他題名:	level up your skill set to Oracle's latest and most powerful features in sql, pl/sql, and json /
作者:	Nuijten, Alex.
其他作者:	Barel, Patrick.
出版者:	Berkeley, CA :Apress : : 2023.,
面頁冊數:	xxviii, 576 p. :ill., digital ;24 cm.
內容註:	Part I. The Advanced Basics -- 1. Underutilized Functionality and Enhancements -- 2. Analytic Functions, Model, and Pivoting -- 3. Joins -- 4. Finding Patterns -- 5. Pagination and Set Operators -- 6. Conditional Compilation -- 7. Iterations and Qualified Expressions -- Part II. Multiple Techniques and Languages -- 8. SQL Macro and Polymorphic Table Functions and SQL Macros -- 9. Subquery Factoring, the WITH Clause Explained -- 10. Calling PL/SQL from SQL -- 11. Storing JSON in the Database -- 12. Creating and Parsing JSON in SQL -- 13. Creating and Parsing JSON in PL/SQL -- Part III. Oracle-Provided Functionality -- 14.Comparing and Manipulating JSON -- 15. Useful APEX Packages -- 16. Processing Data in the Background -- 17. Introspecting PL/SQL -- 18. See What You Need to See -- 19. Upgrade your Application with Zero Downtime -- 20. Choosing the Right Table.
Contained By:	Springer Nature eBook
標題:	Database management. -
電子資源:	https://doi.org/10.1007/978-1-4842-9166-5
ISBN:	9781484291665

Modern Oracle Database programming = level up your skill set to Oracle's latest and most powerful features in sql, pl/sql, and json /
Nuijten, Alex.

Modern Oracle Database programminglevel up your skill set to Oracle's latest and most powerful features in sql, pl/sql, and json /[electronic resource] :by Alex Nuijten, Patrick Barel. - Berkeley, CA :Apress :2023. - xxviii, 576 p. :ill., digital ;24 cm.

Part I. The Advanced Basics -- 1. Underutilized Functionality and Enhancements -- 2. Analytic Functions, Model, and Pivoting -- 3. Joins -- 4. Finding Patterns -- 5. Pagination and Set Operators -- 6. Conditional Compilation -- 7. Iterations and Qualified Expressions -- Part II. Multiple Techniques and Languages -- 8. SQL Macro and Polymorphic Table Functions and SQL Macros -- 9. Subquery Factoring, the WITH Clause Explained -- 10. Calling PL/SQL from SQL -- 11. Storing JSON in the Database -- 12. Creating and Parsing JSON in SQL -- 13. Creating and Parsing JSON in PL/SQL -- Part III. Oracle-Provided Functionality -- 14.Comparing and Manipulating JSON -- 15. Useful APEX Packages -- 16. Processing Data in the Background -- 17. Introspecting PL/SQL -- 18. See What You Need to See -- 19. Upgrade your Application with Zero Downtime -- 20. Choosing the Right Table.

Level up your skill set to the latest that Oracle Database can offer. This book introduces features that are not well known that can transform your development efforts. You'll discover built-in functionality that can save you massive amounts of time that otherwise would be spent reinventing the wheel. You'll find that what used to take a lot of programming some years ago can be done with less code in a more reliable way today. Anyone using Oracle Database without the knowledge in this book is leaving valuable functionality-that their company has paid for-on the table, and this book opens the door to that functionality so that you can deliver reliable and performant solutions faster and more easily than ever. Part I looks at features in SQL and PL/SQL that are underused and not well known. You'll learn about new join types, pattern matching across rows, Top N pagination (useful in reporting!), qualified expressions, and enhancements to iterators that reduce code complexity and make your logic easier to understand. Part II covers how and when to invoke PL/SQL from SQL while maintaining performance. You'll learn about SQL macro functions for creating reusable SQL fragments, polymorphic table functions with return types determined by incoming argument types, and constructing and parsing JSON documents for data interchange with other systems. Part III introduces a vast array of built-in functionality that Oracle provides that is just waiting to be used. Edition-based redefinition enables zero-downtime application and schema upgrades. Data redaction enables easier compliance with privacy laws and similar regulations by protecting sensitive data from those who have no need to see it. Virtual private databases provide the appearance of giving each user their own database, again helping to secure sensitive data. These features are just a taste of what the book provides. Soon you'll be improving your skills and wondering why you ever worked so hard to solve problems that Oracle Database already solves for you. What You Will Learn Write more powerful code by incorporating underused features in SQL and PL/SQL Optimize your integration between SQL and PL/SQL for best performance Take advantage of enhanced set operators, lateral joins, row-based pattern matching, and other advanced features in SQL Make your code easier to understand through your use of newer PL/SQL features, such as qualified expressions and iterator enhancements Integrate with web services and external data sources directly from the database Create and parse JSON documents for easy data exchange and flexible schema design.

ISBN: 9781484291665

Standard No.: 10.1007/978-1-4842-9166-5doiSubjects--Uniform Titles:

Oracle (Computer file)
Subjects--Topical Terms:

527442
Database management.

LC Class. No.: QA76.9.D3 / N85 2023

Dewey Class. No.: 005.7585

Modern Oracle Database programming = level up your skill set to Oracle's latest and most powerful features in sql, pl/sql, and json /
LDR:04590nmm a2200325 a 4500 001 2316504
003 DE-He213
005 20230221093229.0
006 m d
007 cr nn 008maaau
008 230902s2023 cau s 0 eng d
020 $a 9781484291665 $q (electronic bk.)
020 $a 9781484291658 $q (paper)
024 7 $a 10.1007/978-1-4842-9166-5 $2 doi
035 $a 978-1-4842-9166-5
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.9.D3 $b N85 2023
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
082 0 4 $a 005.7585 $2 23
090 $a QA76.9.D3 $b N968 2023
100 1 $a Nuijten, Alex. $3 3629782
245 1 0 $a Modern Oracle Database programming $h [electronic resource] : $b level up your skill set to Oracle's latest and most powerful features in sql, pl/sql, and json / $c by Alex Nuijten, Patrick Barel.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2023.
300 $a xxviii, 576 p. : $b ill., digital ; $c 24 cm.
505 0 $a Part I. The Advanced Basics -- 1. Underutilized Functionality and Enhancements -- 2. Analytic Functions, Model, and Pivoting -- 3. Joins -- 4. Finding Patterns -- 5. Pagination and Set Operators -- 6. Conditional Compilation -- 7. Iterations and Qualified Expressions -- Part II. Multiple Techniques and Languages -- 8. SQL Macro and Polymorphic Table Functions and SQL Macros -- 9. Subquery Factoring, the WITH Clause Explained -- 10. Calling PL/SQL from SQL -- 11. Storing JSON in the Database -- 12. Creating and Parsing JSON in SQL -- 13. Creating and Parsing JSON in PL/SQL -- Part III. Oracle-Provided Functionality -- 14.Comparing and Manipulating JSON -- 15. Useful APEX Packages -- 16. Processing Data in the Background -- 17. Introspecting PL/SQL -- 18. See What You Need to See -- 19. Upgrade your Application with Zero Downtime -- 20. Choosing the Right Table.
520 $a Level up your skill set to the latest that Oracle Database can offer. This book introduces features that are not well known that can transform your development efforts. You'll discover built-in functionality that can save you massive amounts of time that otherwise would be spent reinventing the wheel. You'll find that what used to take a lot of programming some years ago can be done with less code in a more reliable way today. Anyone using Oracle Database without the knowledge in this book is leaving valuable functionality-that their company has paid for-on the table, and this book opens the door to that functionality so that you can deliver reliable and performant solutions faster and more easily than ever. Part I looks at features in SQL and PL/SQL that are underused and not well known. You'll learn about new join types, pattern matching across rows, Top N pagination (useful in reporting!), qualified expressions, and enhancements to iterators that reduce code complexity and make your logic easier to understand. Part II covers how and when to invoke PL/SQL from SQL while maintaining performance. You'll learn about SQL macro functions for creating reusable SQL fragments, polymorphic table functions with return types determined by incoming argument types, and constructing and parsing JSON documents for data interchange with other systems. Part III introduces a vast array of built-in functionality that Oracle provides that is just waiting to be used. Edition-based redefinition enables zero-downtime application and schema upgrades. Data redaction enables easier compliance with privacy laws and similar regulations by protecting sensitive data from those who have no need to see it. Virtual private databases provide the appearance of giving each user their own database, again helping to secure sensitive data. These features are just a taste of what the book provides. Soon you'll be improving your skills and wondering why you ever worked so hard to solve problems that Oracle Database already solves for you. What You Will Learn Write more powerful code by incorporating underused features in SQL and PL/SQL Optimize your integration between SQL and PL/SQL for best performance Take advantage of enhanced set operators, lateral joins, row-based pattern matching, and other advanced features in SQL Make your code easier to understand through your use of newer PL/SQL features, such as qualified expressions and iterator enhancements Integrate with web services and external data sources directly from the database Create and parse JSON documents for easy data exchange and flexible schema design.
630 0 0 $a Oracle (Computer file) $3 539566
650 0 $a Database management. $3 527442
650 0 $a SQL (Computer program language) $3 606987
650 0 $a PL/SQL (Computer program language) $3 731565
650 0 $a JSON (Document markup language) $3 2135005
650 1 4 $a Database Management. $3 891010
650 2 4 $a Programming Language. $3 3538935
650 2 4 $a Database Management System. $3 3591759
700 1 $a Barel, Patrick. $3 3629783
710 2 $a SpringerLink (Online service) $3 836513
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-1-4842-9166-5
950 $a Professional and Applied Computing (SpringerNature-12059)