Oracle SQL & PL/SQL

INTRODUCTION : - SQL usually pronounced as “Sequel” stands for Structured Query Language. SQL is the native language of the Oracle Server. It is the language used to communicate with the database. Again SQL consists of SQL statements and SQL*Plus commands. SQL statements are used to talk to the database. When you enter a SQL statement, it is stored in a part of the memory called the SQL Buffer and remains there until a new statement is entered. SQL*Plus is an Oracle tool that recognizes and submits  SQL statements to the Oracle server for execution and contains its own command language. Features of SQL:- It is very easy to write, it can be used by all kinds of users with little or not programming experience. It is a non-procedural language. It reduces the amount of time required for creating and maintaining systems. It is based on American National Standards Iinstitute (ANSI) standard SQL. It manipulates data and ...