SQL usage by its very nature is extremely flexible. It uses a free form syntax that gives the user the ability to structure SQL statements in a way best suited to him. Each SQL request is parsed by the DBMS before execution, to check for proper syntax and to optimize the request. Unlike certain programming languages, there is no need to start SQL statements in a particular column or be finished in a single line. The same SQL request can be written in a variety of ways. The origins of SQL are based on the felt need for such a flexible query language. The SQL developed after the need for it was specified is evident from the relatively few commands it has. Throughout its life cycle, SQL received natural extensions to its functional capabilities, and what was originally intended as a query language has now become the complete Database language.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

IBM Mainframe Topics