Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c About This Book Learn advanced application development features of Oracle Database 12c and prepare for the 1Z0-146 examination Build robust and secure applications in Oracle PL/SQL using the best practices Packed with feature demonstrations and illustrations that will help you learn and understand the enhanced capabilities of Oracle Database 12c Who This Book Is For This book is for Oracle developers responsible for database management. Readers are expected to have basic knowledge of Oracle Database and the fundamentals of PL/SQL programming. Certification aspirants can use this book to prepare for 1Z0-146 examination in order to be an Oracle Certified Professional in Advanced PL/SQL. What You Will Learn Learn and understand the key SQL and PL/SQL features of Oracle Database 12c Understand the new Multitenant architecture and Database In-Memory option of Oracle Database 12c Know more about the advanced concepts of the Oracle PL/SQL language such as external procedures, securing data using Virtual Private Database (VPD), SecureFiles, and PL/SQL code tracing and profiling Implement Virtual Private Databases to prevent unauthorized data access Trace, analyze, profile, and debug PL/SQL code while developing database applications Integrate the new application development features of Oracle Database 12c with the current concepts Discover techniques to analyze and maintain PL/SQL code Get acquainted with the best practices of writing PL/SQL code and develop secure applications In Detail Oracle Database is one of the most popular databases and allows users to make efficient use of their resources and to enhance service levels while reducing the IT costs incurred. Oracle Database is sometimes compared with Microsoft SQL Server, however, Oracle Database clearly supersedes SQL server in terms of high availability and addressing planned and unplanned downtime. Oracle PL/SQL provides a rich platform for application developers to code and build scalable database applications and introduces multiple new features and enhancements to improve development experience. Advanced Oracle PL/SQL Developer's Guide, Second Edition is a handy technical reference for seasoned professionals in the database development space. This book starts with a refresher of fundamental concepts of PL/SQL, such as anonymous block, subprograms, and exceptions,...

PL/SQL (Computer program language) --- Database design. --- Data base design --- System design --- Procedural Language/SQL --- Query languages (Computer science) --- Oracle (Computer file) --- Oracle7.3 --- Oracle 7.3 --- Personal Oracle7 --- Personal Oracle 7

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

PL/SQL (Computer program language) --- Relational databases --- Relational data bases --- Databases --- Procedural Language/SQL --- Query languages (Computer science) --- Contains audio-visual material --- Relational databases. --- PL/SQL (Computer program language). --- Oracle (Computer file) --- Oracle7.3 --- Oracle 7.3 --- Personal Oracle7 --- Personal Oracle 7

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales extensive experience to discover the most commonly used aspects of PL/SQL, without wasting time with obscure and obsolete features. Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule: cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL. Discover the 20% of PL/SQL that gives you 80% of the bang! Key topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more. Learn how to write production-level, object-oriented PL/SQL. You'll explore relational PL/SQL, but unlike most other books on the subject, this one emphasizes the use of PL/SQLs object-oriented features as well. Work through real examples of using of PL/SQL. You'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.

PL/SQL (Computer program language) --- Relational databases. --- Oracle (Computer file) --- Relational data bases --- Databases --- Procedural Language/SQL --- Query languages (Computer science) --- Oracle7.3 --- Oracle 7.3 --- Personal Oracle7 --- Personal Oracle 7 --- Information Technology --- General and Others --- Database management. --- Software engineering. --- Database Management. --- Software Engineering/Programming and Operating Systems. --- Computer software engineering --- Engineering --- Data base management --- Data services (Database management) --- Database management services --- DBMS (Computer science) --- Generalized data management systems --- Services, Database management --- Systems, Database management --- Systems, Generalized database management --- Electronic data processing --- Oracle (Computer software)

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Oracle Application Express 4 Recipes provides an example-based approach to learning Application Express—the ground-breaking, rapid application development platform included with every Oracle Database license. The recipes format is ideal for the quick-study who just wants a good example or two to kick start their thinking and get pointed in the right direction. The recipes cover the gamut of Application Express development. Author and Application Express expert Edmund Zehoo shows how to create data entry screens, visualize data in the form of reports and charts, implement validation and back-end logic, and much more. Solutions are presented in an easy problem/solution format, which you can copy and adapt for your own use. Detailed discussion for each solution deepens your understanding and aids in customizing the solutions to fit your particular development challenges. Teaches Application Express via an example-based format Takes you from beginner to intermediate level Shows how to build a fully-functional web store in just one hour.

Engineering & Applied Sciences --- Computer Science --- Information Technology --- Computer Science (Hardware & Networks) --- General and Others --- PL/SQL (Computer program language) --- Application software --- Development. --- Oracle (Computer file) --- Development of application software --- Procedural Language/SQL --- Oracle7.3 --- Oracle 7.3 --- Personal Oracle7 --- Personal Oracle 7 --- Computer science. --- Software engineering. --- Database management. --- Computer Science. --- Software Engineering/Programming and Operating Systems. --- Database Management. --- Data base management --- Data services (Database management) --- Database management services --- DBMS (Computer science) --- Generalized data management systems --- Services, Database management --- Systems, Database management --- Systems, Generalized database management --- Electronic data processing --- Computer software engineering --- Engineering --- Informatics --- Science --- Query languages (Computer science)

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

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.

Database management. --- Programming languages (Electronic computers). --- Database Management. --- Programming Language. --- Database Management System. --- Data base management --- Data services (Database management) --- Database management services --- DBMS (Computer science) --- Generalized data management systems --- Services, Database management --- Systems, Database management --- Systems, Generalized database management --- Electronic data processing --- Computer languages --- Computer program languages --- Computer programming languages --- Machine language --- Languages, Artificial --- JSON (Document markup language) --- PL/SQL (Computer program language) --- Oracle (Computer file) --- Procedural Language/SQL --- Query languages (Computer science) --- JavaScript Object Notation (Document markup language) --- Document markup languages --- Oracle7.3 --- Oracle 7.3 --- Personal Oracle7 --- Personal Oracle 7 --- SQL (Computer program language) --- Structured Query Language (Computer program language) --- Declarative programming languages