PL SQL Tutorial
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 is object-relational langauge,but at its core,it is a relational,procedural programming language
Memory Areas in PL/SQL, UGA(User Defined Global Area,) PGA Program Defined Glocal Area, SGA System Defined Global Areas.
PL/SQL Can be Used to Process XML Tree Nodes
PL/SQL Can be Used to Process JSON Data Format
PL/SQL Can be Used to load External Files into the Database
PL/SQL Can be Used to CLOB and BLOB and BFILE types into Database
PL/SQL doesnot support Multi-Threading, but same thing can be achived using PIPE LINE Functions
PL/SQL supports collection Objects as a Table Column
ADS