PL/SQL Class Notes 1-> Introduction , PLSQL Block structure,PLSQL Variables ,Banking Table creation,Nested Block, Labeled block
Pl/SQL Simple Notes Ø PL/SQL is a procedural language and which is extension to a non-procedural language SQL. It is a block structured language. PL/SQL tells how to do, SQL tells what to do. Ø A collection of Executable statements is called Block. Pl/SQL block is a logical collection of procedural and non-procedural statements. Ø Pl/SQL features § It is developed by oracle company in 1980’s. § It is used by only oracle whereas SQL can be used by any RDBMS, DBMS technologies. § It processes only one row at a time. § It supports executable block of statements at once. § It supports variables & Constraints, SQL-bind variables, PL/SQL bind and host variables. § It supports error handling. § It supports conditional statements (if, else, if-else). § It supports interaction controls (while loop, for loop….). § It supports sub-programs 1. ...