Skip to main content

Posts

Showing posts with the label Anonymous PL/SQL Block

PL/SQL in Oracle and basic Programs in PL/SQL #Diksha Oracle Training Centre

              PL/SQL in Oracle with basic Programs. Hello Everyone, Today I will discuss about PL/SQL in Oracle .In Previous Blog we discussed about cursor and anonymous block used in cursor as well as uses of %TYPE and %ROWTYPE attribute. Before starting this topic please go through my below blog. https://dikshaoracletraining.blogspot.com/2020/10/cursor-and-types-of-cursor-in-oracle.html https://dikshaoracletraining.blogspot.com/2020/11/benefits-of-type-and-rowtype-in-oracle.html PL/SQL is basically a Procedural Language in SQL and in PL/SQL we use separate two parts first is Anonymous Block and second is Named Block. The PL/SQL programming language was developed by Oracle Corporation in the late 1980s as procedural extension language for SQL relational database. PL/SQL high-performance transaction-processing language.PL/SQL is completely portable.   PL/SQL provides a built-in, interpreted and OS independent programming environment. ...