Curriculum
Course: Complete Oracle Apex Web Application Dev...
Login

Curriculum

Complete Oracle Apex Web Application Development Training

Course Overview

0/3

Oracle SQL

0/2

Install Oracle

0/6

SQL Query : Common SQL*PLUS commands

0/1

SQL Query : Writing Basic SQL Statements

0/6

SQL Query : Restricting Data

0/7

SQL Query : Sorting Data

0/3

SQL Query : Single Row Functions

0/10

SQL Query : Displaying Data from Multiple Tables

0/5

SQL Query : Aggregating Data Using Group Functions

0/5

SQL Query : Subqueries

0/7

SQL DDL : Creating and Managing Tables

0/8

SQL DDL : Including Constraints

0/5

SQL DDL : Creating and Managing Views

0/1

SQL Data Manipulation Language (DML)

0/4

SQL Other Database Objects

0/3

SQL Data Control Language (DCL)

0/1

SQL Transaction Control

0/2

SQL Others

0/3

Oracle SQL Quiz and Free E-books

0/2

Oracle PLSQL - Introduction

0/1

PLSQL - Declaring PLSQL Variables

0/7

Writing Executable Statements

0/5

Writing Control Structure

0/4

Iterative Processing with loops

0/4

Using Cursors

0/5

Handling exceptions

0/2

Creating Procedures

0/3

Creating Functions

0/1

Creating Packages

0/1

Creating Triggers

0/5

Oracle Apex

0/2

Installation of Oracle Apex

0/5

Creating a Desktop and Mobile Database Application

0/4

Working with Reports for Mobile Application

0/4

Creating Forms

0/3

Working with Pages and Regions

0/2

Adding Items and Buttons

0/3

Understanding Session State

0/1

Including DML Page Processing

0/7

Creating Charts and Calendars

0/2

Using Dynamic Actions and Plug-ins

0/2

Software Projects on Human Resource Management Systems

0/21

Software Project: Automobile Workshop Management Systems (Sales Apps)

0/14

Oracle Apex on Cloud – Build Oracle Apex Environment on Cloud VPS

0/11
Text lesson

Introduction to PL/SQL

Introduction to PL/SQL :

PL/SQL, the Oracle procedural extension of SQL, is a portable, high-performance transaction-processing language.

  1. Procedural Language/Structured Query Language.
  2. Significant Member of Oracle Programming Language.
  3. Extensively Used to Code Server Side
  4. Case In-Sensitive Language.

PL/SQL stands for procedural language-structured query language. It is a significant member of Oracle programming tool set which is extensively used to code server side programming. Similar to SQL language PL/SQL is also a case-insensitive programming language.

Advantages of PL/SQL : PL/SQL has these advantages:

  1. Tight Integration with SQL.
  2. High Performance.
  3. High Productivity.
  4. Support for Object-Oriented Programming.

Main Features of PL/SQL :

PL/SQL combines the data-manipulating power of SQL with the processing power of procedural languages. When you cannot solve a problem with SQL, you can issue SQL statements from your PL/SQL program, without learning new APIs. Like other procedural programming languages, PL/SQL lets you declare constants and variables, control program flow, define subprograms, and trap runtime errors. You can break complex problems into easily understandable subprograms, which you can reuse in multiple applications. Features Includes :

  1. Procedures and functions.
  2. Error Handling.
  3. Variables and Constants.
  4. Input and Output.
  5. Data Abstraction.
  6. Control Statements.
  7. Conditional Compilation.
  8. Processing a Query Result Set One Row at a Time.

Architecture of PL/SQL Basic understanding of the PL/SQL architecture is beneficial to PL/SQL programmers. PL/SQL Engine :

  1. The PL/SQL compilation and runtime system is an engine that compiles and runs PL/SQL units.
  2. The engine can be installed in the database or in an application development tool, such as Oracle Forms or Oracle Apex.
  3. In either environment, the PL/SQL engine accepts as input any valid PL/SQL unit. The engine runs procedural statements, but sends SQL statements to the SQL engine in the database.

Next
Live Courses