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; Barel, Patrick

ISBN 10: 1484291654 ISBN 13: 9781484291658

Editorial: Apress, 2023

Idioma: Ingl�s

Condici�n: Nuevo Encuadernaci�n de tapa blanda

Guardar para m�s tarde

Vendido por Ria Christie Collections, Uxbridge, Reino Unido

Vendedor de AbeBooks desde 25 de marzo de 2015

Calificaci�n del vendedor: 5 de 5 estrellas

Ver los art�culos de este vendedor

Ver todos los ejemplares de este libro

Nuevos - Encuadernaci�n de tapa blanda

Condici�n: Nuevo

Precio: EUR 58,80 Convertir moneda

EUR 5,18 gastos de env�o desde Reino Unido a Espa�a Destinos, gastos y plazos de env�o

Cantidad disponible: M�s de 20 disponibles

A�adir al carrito

Guardar para m�s tarde

Descripci�n

In.

N� de ref. del art�culo ria9781484291658_new

Contactar al vendedor

Denunciar este art�culo

Detalles bibliogr�ficos

T�tulo

Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

Editor

Apress

Fecha de publicaci�n

2023

Idioma

Ingl�s

ISBN 10

1484291654

ISBN 13

9781484291658

Encuadernaci�n

Encuadernaci�n de tapa blanda

Estado

New

Cat�logos de vendedores

Acerca de

Sinopsis

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

Who This Book Is For

Any developer who is writing SQL or PL/SQL, PL/SQL experts who want to level up their knowledge and skills to the latest features that Oracle Database provides, and developers who don't want to write their own solutions only to find out later that they've wasted their time by building something that Oracle Database provides out of the box

Acerca del autor

Alex Nuijten is an independent consultant specializing in Oracle database development with PL/SQL and Oracle Application Express (APEX). Besides his consultancy work, he conducts training classes in APEX, SQL, and PL/SQL. He is a speaker at numerous international conferences, such as ODTUG, Oracle Open World, HrOUG, UKOUG, IOUG, OUGF, BGOUG, NLOUG APEX World, OBUG, and many more. He has received several Best Speaker awards and writes at regular intervals about Oracle Application Express and Oracle database development on his blog "Notes on Oracle." He is co-author of Oracle APEX Best Practices and Real World SQL and PL/SQL. Because of his contributions to the Oracle community, Alex was awarded the Oracle ACE Director membership in August 2010.
Patrick Barel is a PL/SQL developer for Qualogy in The Netherlands. Besides working with SQL and PL/SQL Developer, he has written different plug-ins for PL/SQL. He publishes articles on his own blog and on the Qualogy blog. He is a speaker at international conferences, such as ODTUG, UKOUG, AUSOUG, NZOUG, IOUG, OUGN, NLOUG, DOUG, HrOUG, and many more. Patrick was awarded the Oracle ACE membership. In 2015, he received the Oracle Developer Choice Award in the PL/SQL Category. In 2019, he was promoted to Oracle ACE Director.

"Sobre este t�tulo" puede pertenecer a otra edici�n de este libro.

Descripci�n de la librer�a

Hello! Ria Christie Collections is an online venture that was initially set up in 2012 to sell books. We do not have a physical high street store. We are professional online booksellers. We only sell brand new books in perfect condition that we source from various suppliers and the publishers. Primarily, our aim is to provide an excellent service to all our customers. We always work as a team to achieve this. Our other objectives are to: 1. Ensure that all our products reach their destination quickly in a safe and secure manner 2. Answer to all our customer queries within 24 hours 3. Ensure that our customers are happy with their purchases 4. Provide all the items at a competitive price 5. Always listen to our customers Ria Christie Collections is not a registered company. It is a Sole Trader venture. Other key information is shown below: Contact Person Name: Rakesh Luchmun (Mr) Storefront Name: Ria Christie Collections Place of Establishment Address: Suite B; ARUN House; ARUN Building Arundel Road Uxbridge UB8 2RR United Kingdom E-Mail Address: riachristie@hotmail.co.uk VAT Number: GB 160 5650 25 We always work hard and aim to comply with all of Abebooks Policies. If you have any issues, please do not hesitate to write to us whether before or after a purchase. We promise to reply to you promptly and, in any case, within 24 hours. Thank you kindly! Yours sincerely Mr Rakesh Luchmun (Founder) and the Ria Christie Collections Team

Ver la p�gina web de la librer�a

Informaci�n empresarial del vendedor

Ryefield Investments Limited
175 Pield Heath Road, Uxbridge, UB8 3NL, United Kingdom

Condiciones de venta y env�o

Condiciones de venta

All Returns and Refund are as per Abebooks policies.

Derecho a cancelaci�n

Condiciones de env�o

Orders usually ship within 2 business days. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required. Thank you!

Tarifas de env�o de Reino Unido a Espa�a

Tarifas de env�o de Reino Unido a Espa�a
Cantidad del pedido	De 5 a 8 d�as h�biles	De 5 a 8 d�as h�biles
Primer art�culo	EUR 5.18	EUR 5.18

Los plazos de entrega los establecen los vendedores y var�an seg�n el transportista y la ubicaci�n. Los pedidos que pasan por la aduana pueden sufrir retrasos y los compradores son responsables de los aranceles o tarifas asociadas. Los vendedores pueden ponerse en contacto con usted en relaci�n con cargos adicionales para cubrir cualquier aumento en los costes de env�o de los art�culos.