Why Use SQL?
If you want to access and manipulate Oracle data, you need SQL. Whether you use SQL interactively through SQL*Plus or embedded in an application program depends on the job at hand. If the job requires the procedural processing power of C or C++, or must be done on a regular basis, use embedded SQL. SQL has become the database language of choice because it is flexible, powerful, and easy to learn. Being non-procedural, it lets you specify what you want done without specifying how to do it. A few English-like statements make it easy to manipulate Oracle data one row or many rows at a time. You can execute any SQL (not SQL*Plus) statement from an application program. For example, you can CREATE, ALTER, and DROP database tables dynamically SELECT, INSERT, UPDATE, and DELETE rows of data COMMIT or ROLLBACK transactions Before embedding SQL statements in an application program, you can test them interactively using SQL*Plus. Usually, only minor changes are required to switch from interactive
