Beginning Oracle PL/SQL
Beginning Oracle PL/SQL gets you started in using the built-in language that every Oracle developer and database administrator must know. Oracle Database is chock-full of built-in application features that are free for the using, and PL/SQL is your ticket to learning about and using those features f...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2015.
|
| Edición: | 2nd ed. 2015. |
| Colección: | Expert's voice in Oracle.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629943606719 |
Tabla de Contenidos:
- Contents at a Glance; Introduction (The Big Picture); Chapter 1: Relational SQL; Tables; An Entity-Relationship Diagram; Data Definition Language ( DDL); It's Your Turn to Create a Table; Indexes; DDL Again; It's Your Turn to Create an Index; Constraints; Column Constraints; Table Constraints; Unique Key Constraint; Primary Key Constraint; Foreign Key Constraint; It's Your Turn to Create a Constraint; Triggers; Views; Insert; Insert . . .Values; It's Your Turn to Insert with Values; Insert . . . Select; It's Your Turn to Insert with Select; Update; Fix a Mistake with Update
- It's Your Turn to UpdateUpdate and Subqueries; Delete; A Change in Order; It's Your Turn to Delete; Select; Joins; Joins in a Where Clause; Joins in a From Clause; It's Your Turn to Select; Your Working Example; Your Example Narrative; Your Example ERD; Content; Codes; Intersections; Create a Code Table; It's Your Turn to Create Code Tables; Create a Content Table; It's Your Turn to Create Content Tables; Create an Intersection Table; It's Your Turn to Create Intersection Tables; Summary; Chapter 2: Blocks, Functions, and Procedures; Blocks; Anonymous Blocks; Anonymous Block Example
- It's Your Turn to Execute an Anonymous BlockExceptions; Common Exceptions; Catching an Exception; Functions; Create a Function; It's Your Turn to Create a Function; Procedures; Create a Procedure; It's Your Turn to Create a Procedure; Nested Blocks; An Example of Nesting Blocks; Rules for Nesting; Packages; Create a Package Specification; It's Your Turn to Create a Package Specification; Create a Package Body; It's Your Turn to Create a Package Body; Benefits of Using Packages; Summary; Chapter 3: Types, Variables, and Scope; PL/SQL Data Types; Variables; Variable Naming
- Variable DeclarationsVariable Anchors; Variable Assignments; NULL Value; It's Your Turn to Declare Variables; Scope; Scope Rules; It's Your Turn to Scope Things Out; Types; Table Types; Record Types; Multidimensional Arrays; Parameters; Parameter Naming; Parameter Declarations; Parameter Scope; It's Your Turn to Declare Parameters; Summary; Chapter 4: Single Row Processing; Inserts; Catching a DUP_VAL_ON_INDEX Exception; Using PL/SQL to Predetect a Duplicate; IF I Don't Tell You Now, When ELSE Can I?; Using SQL to Predetect a Duplicate; It's Your Turn to Insert; Updates; Updating a Row
- Using SQL to Perform Complex UpdatesDeletes; Selects; No Data Found; Too Many Rows; It's Your Turn to Select; Summary; Chapter 5: Multirow Processing; Cursors; Cursor Declarations; Fetching Rows from a C ursor Manually; Cursor Records; A Singleton Cursor; It's Your Turn to Fetch Manually; A Code Table Package; A Worker Table Package; Write a Modularized Version of In sert with PL/SQL Detection; My Solution; Fetching Rows from a Cursor Automatically; It's Your Turn to Fetch Automatically; Bulk Collect; Bulk Collect with a Cursor; Bulk Collect with a Select Statement
- It's Your Turn to Bulk Collect
