Database Reference
In-Depth Information
Chapter 2:
SQL: Structured Query Language
What is SQL?
Like I said in the previous chapter that SQL is the language that
we will be using to communicate with the Instance. It's just like,
I am right now using “English” as a way of communication
because you guys understand it. Similarly, to communicate with
Oracle Instance we use SQL (Seeqal). Before we proceed with
the language I want to clarify three terms that is used widely and
sometimes few people gets confused. These are SQL, PL/SQL
and SQL*Plus. SQL as I already told you is the language to
communicate with Oracle Instance whereas PL/SQL is the
superset of SQL i.e. we use PL/SQL instead of SQL when our
target/goal requires multiple SQL commands to be executed
based on certain logic, event or condition then we take the
benefit of this language.
SQL*Plus is basically the environment where we write SQL or
PL/SQL commands. In other words it's a front end tool we use
to communicate with Oracle Instance. There are lots of SQL
front-end tools available but it's the one that gets installed once
Search WWH ::
Custom Search