Learn PL/SQL in 1 Day: Definitive Guide to Learn PL/SQL for Beginners por Krishna Rungta

Learn PL/SQL in 1 Day: Definitive Guide to Learn PL/SQL for Beginners por Krishna Rungta

Titulo del libro: Learn PL/SQL in 1 Day: Definitive Guide to Learn PL/SQL for Beginners

Autor: Krishna Rungta

Número de páginas: 143 páginas

Fecha de lanzamiento: November 23, 2016

Obtenga el libro de Learn PL/SQL in 1 Day: Definitive Guide to Learn PL/SQL for Beginners de Krishna Rungta en formato PDF o EPUB. Puedes leer cualquier libro en línea o guardarlo en tus dispositivos. Cualquier libro está disponible para descargar sin necesidad de gastar dinero.

Krishna Rungta con Learn PL/SQL in 1 Day: Definitive Guide to Learn PL/SQL for Beginners

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

Libros Relacionados