What is PL SQL and what is it used for? PL/SQL(Procedural Language extensions to SQL) is basically a programming language in Oracle database. PL/SQL allows …
Read More »Yusuf SEZER
Oracle PL/SQL Cursor
This article contains information about Oracle PL/SQL Cursor and example about PL/SQL Cursor. What is Oracle PL/SQL Cursor? When the data in a table is …
Read More »Oracle PL/SQL Records
This article contains information about Oracle PL/SQL Records such as Table Based, Cursor Based and User Defined Records. What is Record in Oracle? Data types …
Read More »Oracle PL/SQL Exception
This article contains information about Oracle PL/SQL Exception and Types such as system defined, user defined. What is Exception in Oracle PL/SQL? These are the …
Read More »Oracle PL/SQL Trigger
This article contains information about Oracle PL/SQL Trigger, Types such as DML,DDL and Datase Triggers and examples. What is Trigger in Oracle PL/SQL? The structure …
Read More »Oracle PL/SQL Packages
This article contains information about Oracle PL/SQL Packages, create , execute and drop packages and also predefined packages. What is Package in Oracle PL/SQL? Packages …
Read More »Oracle PL/SQL Collections
This article contains information about Oracle PL/SQL Collections, types such as Associative Array, Nested Table and Varray, also collection methods. What is Collection Oracle? Collections …
Read More »Oracle PL/SQL Functions
This article contains information about PL/SQL Functions, and examples. What is Function in Oracle? Oracle PL/SQL functions structure are structures that can store commands under …
Read More »Oracle PL/SQL Procedures and Procedure Parameters
This article contains information about PL/SQL Procedures and parameters in procedures such as IN, OUT, IN OUT. What is Procedure in Oracle? PL/SQL Procedures are …
Read More »Oracle PL/SQL Loops
This article contains information about PL/SQL Loops such as WHILE, FOR and necessary statements for these loops like GOTO, Continue, EXIT. What is loop in …
Read More »