Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

This article contains script to find deleted objects in sql server. It happened to every database administrator. Application developers or your supervisors may ask you …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …