001454882 000__ 05551cam\a22005537i\4500
001454882 001__ 1454882
001454882 003__ OCoLC
001454882 005__ 20230314003233.0
001454882 006__ m\\\\\o\\d\\\\\\\\
001454882 007__ cr\cn\nnnunnun
001454882 008__ 230227s2023\\\\nyua\\\\o\\\\\001\0\eng\d
001454882 019__ $$a1371178147$$a1371215001
001454882 020__ $$a9781484291665$$q(electronic bk.)
001454882 020__ $$a1484291662$$q(electronic bk.)
001454882 020__ $$z9781484291658
001454882 020__ $$z1484291654
001454882 0247_ $$a10.1007/978-1-4842-9166-5$$2doi
001454882 035__ $$aSP(OCoLC)1371240155
001454882 040__ $$aGW5XE$$beng$$erda$$epn$$cGW5XE$$dYDX$$dAU@$$dORMDA$$dEBLCP
001454882 049__ $$aISEA
001454882 050_4 $$aQA76.9.D3
001454882 08204 $$a005.75/85$$223/eng/20230227
001454882 1001_ $$aNuijten, Alex,$$eauthor.$$1https://isni.org/isni/000000040195923X
001454882 24510 $$aModern Oracle Database programming :$$blevel up your skill set to Oracle's latest and most powerful features in SQL, PL/SQL, and JSON /$$cAlex Nuijten, Patrick Barel.
001454882 264_1 $$aNew York :$$bApress,$$c2023.
001454882 300__ $$a1 online resource (576 pages) :$$billustrations (black and white).
001454882 336__ $$atext$$btxt$$2rdacontent
001454882 337__ $$acomputer$$bc$$2rdamedia
001454882 338__ $$aonline resource$$bcr$$2rdacarrier
001454882 347__ $$atext file$$bPDF$$2rda
001454882 500__ $$aIncludes index.
001454882 5050_ $$aPart 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.
001454882 506__ $$aAccess limited to authorized users.
001454882 520__ $$aLevel 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. Youll discover built-in functionality that can save you massive amounts of time that otherwise would be spent reinventing the wheel. Youll 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 functionalitythat their company has paid foron 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. Youll 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 youll 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.
001454882 588__ $$aDescription based on print version record.
001454882 63000 $$aOracle (Computer file)
001454882 650_0 $$aDatabase management.
001454882 650_0 $$aSQL (Computer program language)
001454882 650_0 $$aPL/SQL (Computer program language)
001454882 650_0 $$aJSON (Document markup language)
001454882 655_0 $$aElectronic books.
001454882 7001_ $$aBarel, Patrick,$$eauthor.
001454882 77608 $$iPrint version:$$aNuijten, Alex.$$tModern Oracle Database programming.$$dNew York : Apress, 2023$$z9781484291658$$w(OCoLC)1368278208
001454882 852__ $$bebk
001454882 85640 $$3Springer Nature$$uhttps://univsouthin.idm.oclc.org/login?url=https://link.springer.com/10.1007/978-1-4842-9166-5$$zOnline Access$$91397441.1
001454882 909CO $$ooai:library.usi.edu:1454882$$pGLOBAL_SET
001454882 980__ $$aBIB
001454882 980__ $$aEBOOK
001454882 982__ $$aEbook
001454882 983__ $$aOnline
001454882 994__ $$a92$$bISE