Author: Viswanath A

PL-SQL Packages – Learn how to declare variables, functions, procedures , pl-sql types , constants, exceptions, cursors in Package specification section and how to implement

ORACLE DATA TYPES – Learn about data types classification and their usages with full explanation. ORACLE DATA TYPES This  are built-in(Predefined) data Types. They categorize

User defined exceptions in Oracle – Learn how user can define his own Exceptions depends on the requirements of business logic. User defined exceptions in

PL-SQL Collections and Records- Learn about how collections and Records used in PL-SQL . Also Learn  how collections  and records are classified depends on requirement.

PL-SQL Table based Records-Learn how to declare Table Based records with %ROWTYPE and %TYPE with Examples. Also learn use of %ROWTYPE, %TYPE while managing data

PL-SQL Cursor based Records-Learn how to declare and define a Cursor with select statement. Also Learn use of cursor declaration with %ROWTYPE and cursor field

PL-SQL Programmer defined Records-Learn about Programmer-defined Record declaration , Also Learn how same it is with other languages like C and C# structure related concepts.

PL-SQL Tables- Learn the implementation difference between arrays and PL-SQL Tables with syntax and examples. Also Learn about some predefined Collection Methods used in collections

PL-SQL Nested Tables -Learn how to use Nested tables in PL-SQL. Also learn the similarities and difference between Index By Table, VARRAY, Nested Tables with

Database triggers – Learn when and how trigger works on database tables. Also Learn their classification and usage in different scenarios with examples Database Triggers