If you have mastered the fundamentals of the PL/SQL language and are now looking for an in-depth, practical guide to solving real problems with PL/SQL stored procedures, then this is the book for you.

If you work with Oracle in any capacity, whether as a Java programmer, Database Administrator, or PL/SQL programmer, chances are good that you write SQL statements to query for data within the database. Knowledge of SQL, and particularly of Oracle's implementation of SQL, is the key to writing good queries in a timely manner. In this book, authors Sanjay Mishra and Alan Beaulieu share their knowledge of Oracle SQL, and show you many creative techniques that you can use to advantage in your own applications. Book jacket.

Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92. Both standard SQL and Oracle’s own extensions to the language have progressed far over the decades in terms of how much you can work with your data in a single, albeit sometimes complex, SQL statement. If you already know the basics of SQL, this book provides many examples of how to write even more advanced SQL to huge benefit in your applications, such as:Pivoting rows to columns and columns to rowsRecursion in SQL with MODEL and WITH clausesAnswering Top-N questionsForecasting with linear regressions Row pattern matching to group or distribute rowsUsing MATCH_RECOGNIZE as a row processing engineThe process of starting from simpler statements in SQL, and gradually working those statements stepwise into more complex statements that deliver powerful results, is covered in each example. By trying out the recipes and examples for yourself, you will put together the building blocks into powerful SQL statements that will make your application run circles around your competitors. What You Will LearnTake full advantage of advanced and modern features in Oracle SQL Recognize when modern SQL constructs can help create better applicationsImprove SQL query building skills through stepwise refinementApply set-based thinking to process more data in fewer queriesMake cross-row calculations with analytic functionsSearch for patterns across multiple rows using row pattern matchingBreak complex calculations into smaller steps with subquery factoring Who This Book Is For Oracle Database developers who already know some SQL, but rarely use features of the language beyond the SQL-92 standard. And it is for developers who would like to apply the more modern features of Oracle SQL, but don’t know where to start. The book also is for those who want to write increasingly complex queries in a stepwise and understandable manner. Experienced developers will use the book to develop more efficient queries using the advanced features of the Oracle SQL language.

Using PL/SQL for Oracle Database 21c, you can build solutions that deliver unprecedented performance and efficiency in any environment, including the cloud. Oracle PL/SQL by Example, Sixth Edition, teaches all the PL/SQL skills you'll need, through real-world labs and extensive examples. Now fully updated for the newest version of PL/SQL 21c, it covers everything from basic syntax and program control through the latest optimization and tuning enhancements. Step by step, you'll walk through every key task, mastering today's most valuable Oracle 21c PL/SQL programming techniques on your own. Start by downloading the supporting schema and exercises from informit.com/title/9780138062835. Once you've done an exercise, the author doesn't just present the answer: She offers an in-depth discussion introducing deeper insights and modern best practices. This book's approach fully reflects the author's award-winning experience teaching PL/SQL to professionals at Columbia University in New York City. New database developers and DBAs can use it to get productive fast; experienced PL/SQL programmers will find it to be a superb Oracle Database 21c solutions reference. New in This Edition Updated code examples throughout New iteration controls for the FOR LOOP statement, such as stepped range, multiple iterations, collection, and cursor iterations Enhancements for PL/SQL qualified expressions Performance enhancements for PL/SQL functions, such as SQL macro, and better control of the result cache Other Topics Covered Mastering basic PL/SQL concepts and language fundamentals, and understanding SQL's role in PL/SQL Using conditional and iterative program controls Efficiently handling errors and exceptions Working with cursors and triggers, including compound triggers Using stored procedures, functions, and packages to write modular code that other programs can run Working with collections, object-relational features, native dynamic SQL, bulk SQL, and other advanced features

Learn advanced techniques and best practices of Angular programming for building enterprise web applicationsKey Featuresa- Get familiar with the core concepts of Angular.a- Discover best practices, tips, and tricks while working with Angular.a- Learn how to architect data driven web applications.a- Explore methods to pass data between components in Angular.a- Learn how to deploy and secure your Angular application.DescriptionAngular is a Single Page Application (SPA) development framework open-sourced by Google. The Angular framework is written in TypeScript language, which enables a web developer to write JavaScript code in Object-Oriented fashion. TypeScript makes it easier to build a client-side web application with classes, interfaces, generics, inheritance, and other Object-Oriented features. TypeScript compiler takes care of transpiling these features into native JavaScript. Angular is a framework that comes with Dependency Injection, HTTP communication, Forms, and other features out of the box.This book will leverage on your prior programming knowledge to learn Angular. Microsoft .Net stack, C#, Windows Forms, WPF, ASP.NET have been widely used for developing desktop and web applications. We shall be referring to concepts from these technologies with Angular whenever applicable; thus having prior experience would be a great advantage. This book takes you from the basics of TypeScript language to building modular and robust enterprise web applications and deployment.What will you learna- Learn how to orchestrate complex Angular applications.a- Get to know more about Dependency Injection in depth.a- Learn how to build template and dynamic forms in Angular.a- Learn how to use Angular routes in an application.a- Learn how to communicate with backend services using HTTP.Who this book is forThis book is for readers who want to learn Angular. Having a basic Object-Oriented programming knowledge, programming experience with C#.Net/Java, and hands-on web development experience would be an added advantage.Table of Contents1. Typescript - the underdog2. Hello, Angular!3. Building small and simple4. Data Binding and Pipes5. NgModule - in depth6. Dependency Injection and Services7. Building forms8. Communication within Components9. Consuming HTTP Resources10. Routing Angular application11. Deployment and toolsAbout the AuthorBalram Chavan is a software professional having 11+ years of relevant experience working in cross domains. He has been awarded with GitHub Developer Program Membership for his contribution to open source world. He also contributes to multiple technology blogs and forums. Balram has also published many npm.js packages for Angular framework.Your LinkedIn Profile: https://www.linkedin.com/in/balram-chavan/

*Ideal for anyone who wants to learn SQL programming for Oracle database. *Author has 25 years of teaching experience; 14 years of curriculum develoment experience; 14 years of experience with the Orcle database. *Book can be used as collateral/handouts for SQL training courses at universities/ high schools.

The authors have revised and updated this bestseller to include both the Oracle8i and new Oracle9i Internet-savvy database products.