Oracle PL/SQL

1, PL/SQL and SQL difference :

   

    SQL gives us complete access to our data , By complete, I mean we can get to everything...eventually.. in less than

ideal ways in many cases. There is no guarantee of efficiency and few actual programming capabilities found in most

languages are possible. SQL provides no ability to :

   1) Loop through records, manipulating them one at a time.

   2) Keep code secure by offering encryption ,and storing code permanently on the server rather than the client.

   3) Handle Exception

   4) Work with variables, parameters, collections, records, arrays , objects ,cursors, exceptions,BFILEs,etc

 

    virtually all SQL capabilities are possible with PL/SQL, In fact, the PL/SQL parser is the same as the SQL parser.ensuring that commands are treated the same regardless of where they are excuted.