Besides data operations, the language has administrative and monitoring features which ensure data consistency, integrity, and object controllability. The Structured Query Language or SQL (pronounced "Sequel") has been used as the primary interactive language for all data operations such as selection, creation, and manipulation. ![]() transformed into Oracle and since then, its story has been a success. stepped into the commercial implementation of SQL as the primary RDBMS language. The projected model was accepted and subsequently an interactive database language, SQL, was developed by IBM Corporation, Inc. Codd published his paper, A Relational Model of Data for Large Shared Data Banks, for the ACM journal. Apart from programming, the book also dives deep into the usage of the development tool SQL Developer, employing best practices in database environments and safeguarding the vulnerable areas in PL/SQL code to avoid code injection.Ĭhapter 1. Overview of PL/SQL Programming Concepts The book then covers the advanced features that include PL/SQL code writing using collections, tuning recommendations using result caching, implementing VPD to enforce row level security, and much more. This book starts with an overview of PL/SQL as the programming database language and outlines the benefits and characteristics of the language. It aims to cover the advanced features of PL/SQL for designing and optimizing PL/SQL code. The book gives a deep insight that will help transform readers from mid-level programmers to professional database developers. ![]() Besides the clear and precise explanation on advanced topics, it also contains example code and demonstrations, which gives a sense of application and usage to readers. The Oracle Advanced PL/SQL Developer Professional Guide helps you master advanced PL/SQL concepts. With this guide Oracle developers can work towards accomplishing Oracle 11g Advanced PL/SQL Professional certification, which is the second milestone for developers working at the Associate level. ![]() Server-side PL/SQL is stored and compiled in the Oracle Database and runs within the Oracle executable. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension language for SQL and the Oracle relational database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |