Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux If you get the error “This secondary replica is not connected to the primary replica. The connected state is DISCONNECTED”, it means that you are probably using different endpoints on …
Read More »
Table Point In Time Recovery in 12c(PITR)
This article contains information about table point in time recovery in 12c and later versions and examples. As database administrators, we used to do a lot of superfluous work when …
Read More »
How To Find Deleted Objects in SQL Server
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 to find out who deleted …
Read More » 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 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 listed, we can read the …
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 »