PL SQL Tutorial

PL SQL Introduction

PL SQL Engine submits SQL statements to SQL Engine, SQL Engine is the way to communicate with Database Server. Pl SQL Engine never directly talks to Database Server.

PL/SQL is highly structured Block design with different sections. PL SQL is tightly integrated with SQL.Pl SQL is portable and Standard language for oracle development. You can run PL/SQL applications on any operating Systems and platform where Oracle Server runs.

PL SQL is a statically typed programming language, data types must be declared and checked at compile time.

PL/SQL Architecture

Pl-SQL Architecture

ERROR at line 5: ORA-06550: line 5, column 29: PLS-00642: local collection types not allowed in SQL statements