Sql

SQL was invented and developed by IBM in early 1970’s. SQL stands for structured query language. IBM was able to demonstrate  SQL which could be used to control relational databases. The SQL implemented by ORACLE CORPORATION. Oracle’s database language is SQL, which is used to for storing and retrieving information in oracle. A table is primary database object of SQL that is used to store data.  A table holds data in the form of rows and columns . To communicate with database SQL supports the following  commands.

Advantages of  SQL:-

• Non-procedural language because more than one record can be accessed  rather than one record at a time.
• It is the column language  for all relational databases i.e. portable and it requires only small modifications to make use of in other database.
• Very simple commands for querying, inserting, deleting and modifying and data objects

SQL *PLUS:-                        The SQL *Plus tool is made up two distinct parts. These are

• SQL
• PL/SQL

PL/SQL to create programs for validation and manipulation of table data. PL/SQL adds to the power of interactive Sql and provides the user with all the facilities of a standard, modern day programming environment. Via pl/sql the user can not only manipulate data but also can use procedural techniques such as writing loops or branching to another block of code.

For
Online Classes

Contact Us: +919885348743