Автор: Krishna Rungta
Издательство:
Год: November 23, 2016
Страниц: 209
Язык: английский
Формат: PDF
ISBN:
Аннотация:
- PL/SQL is an extension of SQL for the Oracle Database.
- Learn PL/SQL in 1 Day serves as beginner guide for a crash course in PL/SQL development.
- The book contains tons of examples that prepare you for real-world development project.
- This book is considered the best Oracle PL/SQL programming guide by the Oracle community.
- The books gives clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code.
- Here is what you will learn (книга научит Вас следующему)
Chapter 1: Introduction
- What Is PL/SQL?
- Architecture of PL/SQL
- Advantage of Using PL/SQL
- Basic Difference between SQL and PL/SQL
Chapter 2: Blocks
- What is PL/SQL block?
- Block Structure
- Types of PL/SQL block
Chapter 3: First Program: Hello World
- SQL Plus
- Connecting to Database
- How to write a simple program using PL/SQL
- Declaring and usage of variables in program
- Commenting Codes
Chapter 4: Data Types
- CHARACTER
- NUMBER
- BOOLEAN
- DATE
- LOB
Chapter 5: Complex Data Types
- Record Type
- Collection
- Constructor and Initialization Concept in Collections
- Collection Methods
Chapter 6: Decision Making Statements
- Introduction to Decision Making Statements
- IF-THEN Statement
- IF-THEN-ELSE Statement
- IF-THEN-ELSIF Statement
- NESTED-IF Statement
- CASE Statement
- SEARCHED CASE Statement
Chapter 7: Loops
- Introduction to Loops Concept
- Loop Control Statements
- Types of Loop in PL/SQL
- Nested Loops
- Labelling of Loops
Chapter 8: Subprograms: Procedures and Functions
- Terminologies in PL/SQL Subprograms
- Procedure
- Function
- Similarities between Procedure and Function
- Difference between Procedure and Function
- Built-in Functions in PL/SQL
Chapter 9: Exception Handling
- Exception-Handling
- Predefined Exceptions
- User-defined Exception
- Raising an Exception
- Important points to note in Exception
Chapter 10: SQL
- DML Transactions in PL/SQL
- CURSOR Concept in PL/SQL
- Cursor Attributes
- FOR Loop Cursor statement
- BULK COLLECT in PL/SQL
- TCL Statements in PL/SQL
- Autonomous Transaction
Chapter 11: Packages
- Components of Packages
- Package Initialization
- Forward Declarations
- Overloading
- Package Information
- UTL FILE – An Overview
Chapter 12: Triggers
- Benefits of Triggers
- Trigger Classification
- Trigger Creation
- :NEW and :OLD Clause
- INSTEAD OF Trigger
- Compound Trigger
Chapter 13: Object Types
- Components of Object Types
- Creation of Objects
- Declaration Initialization of Object Type
- Constructors
- Inheritance in Object Type
- Equality of PL/SQL Objects
Chapter 14: Dynamic SQL
- Ways to write dynamic SQL
- NDS
- DBMS_SQL for Dynamic SQL
Chapter 15: Nested Blocks
- Nested Block Structure
- Scopes in Nested Block
Chapter 16: Identifiers
- Properties of Identifiers
- Naming Conventions of Identifiers
- Variables – An Identifier
- Declaration of Variables
- Data storing in Variables
СКАЧАТЬ КНИГУ ИЗ ИНТЕРНЕТА: