Tables are related based on common columns to eliminate data redundancy and ensure data integrity.
A table has rows (or records) and columns (or fields). Object-Oriented Aspects of PL/SQLĪppendix A.This article is applicable to MySQL 8.0, which is the successor of MySQL 5.7, where 5 was dropped?! Introduction to Relational Database and SQL Relational DatabasesĪ relational database organizes data in tables. Globalization and Localization in PL/SQLĬhapter 26. Application Security and PL/SQLĬhapter 25.
Procedures, Functions, and ParametersĬhapter 21. Dynamic SQL and Dynamic PL/SQLĬhapter 17. DML and Transaction ManagementĬhapter 16. Iterative Processing with LoopsĬhapter 14. Conditional and Sequential ControlĬhapter 5. Creating and Running PL/SQL CodeĬhapter 4.
Use the updated online resources available on the book's companion website to accelerate development of your own codeĬhapter 2. Build modular PL/SQL applications using procedures, functions, triggers, and packages. Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture. Optimize PL/SQL performance with tools and techniques such as PL/Scope and the PL/SQL hierarchical profiler. 
Understand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION, BEQUEATH CURRENT_USER for views, and new conditional compilation directives. Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code. Extensive code samples, ranging from easy-to-follow examples to reusable packaged utilities, are available in the book and on the companion website. Thoroughly updated for Oracle Database 12 c Release 1, this edition is packed with syntax, advice, and a great deal of new information.
0 kommentar(er)
