Yusuf SEZER

What is PL/SQL

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 to use structures such as …

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 such as NUMBER, VARCHAR, VARCHAR2 …

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 structures used for the management …

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 used to run a specific …

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 are a structure in which …

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 are data types where values …

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 a name in the database …

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 PL SQL? PL/SQL Loops are …

Read More »