Working of SQL
SQL is the most common language for extracting and organising data that is stored in a relational database. A database is a table that consists of rows and columns. SQL is the language of databases. It facilitates retrieving specific information from databases that are further used for analysis.
The strengths of SQL provide benefits for all types of users, including application programmers, database administrators, managers, and end users. Technically speaking, SQL is a data sub-language. The purpose of SQL is to provide an interface to a relational database such as Oracle Database, and all SQL statements are instructions to the database.
In this SQL differs from general-purpose programming languages like C and BASIC. Among the features of SQL are the following
It processes sets of data as groups rather than as individual units.
It provides automatic navigation to the data.
Not only that, but it uses statements that are complex and powerful individually, and that there forest and alone. Flow- control statements were not part of SQL originally, but they are found in the recently accepted optional part of SQL, ISO/IEC 9075-5: 1996. Flow-control statements are commonly known as
persistent stored modules(PSM), and the PL/SQL extension to Oracle SQL is similar to PSM.
SQL lets we work with data at the logical level. We need to be concerned with the implementation details only when we want to manipulate the data.
For example, to retrieve a set of rows from a table, we define a condition used to filter the rows.
All rows satisfying the condition are retrieved in a single step and can be passed as a unit to the user, to another SQL statement, or to an application.
We need not deal with the rows one by one, nor do we have to worry about how they are physically stored or retrieved.
All SQL statements use the optimizer, a part of Oracle Database that determines the most efficient means of accessing the specified data.
Oracle also provides techniques that we can use to make the optimizer perform its job better.
SQL provides statements for a variety of tasks, including
Inserting, updating, and deleting rows in a table
Creating, replacing, altering, and dropping objects
Controlling access to the database and its objects
Guaranteeing database consistency and integrity
SQL unifies all of the preceding tasks in one consistent language.