Using SQL

• The usage of SQL comes in roughly two flavors as well:

  • Interactive SQL: allows the user to construct and issue SQL commands directly to the database and to view the raw results.
    • Not well suited for automation or rapid processing
  • Embedded SQL: statements are included into and used by some host language such as JAVA or C
    • Allows for rapid processing and pre/post processing of database information.