Sunday, 22 April 2018

PL/SQL Control Structures

PL/SQL Control Structures


Procedural computer programs use the basic control structures.

Friday, 20 April 2018

Database Backup, Restore, and Recovery

A backup is a copy of data from your database that can be used to reconstruct that data. Backups can be divided into physical backups and logical backups. Physical backups are backups of the physical files used in storing and recovering your database, such as datafiles, control files, and archived redo logs.

Wednesday, 18 April 2018

SQL and PL/SQL Database

Structured Query Language (SQL)


SQL is a very simple, yet powerful, database access language. SQL is a non-procedural language; users describe in SQL what they want done, and the SQL language compiler automatically generates a procedure to navigate the database and perform the desired task.

Monday, 16 April 2018

PL/SQL Introduction

PL/SQL is a block structured language that enables developers to combine the power of SQL with procedural statements.All the statements of a block are passed to oracle engine all at once which increases processing speed and decreases the traffic.