SQL Interaction

There are many ways to interact with a Database using SQL. Most of the following queries were done on randomly generated data:

• Data Selection-Extracting Data from the Database
• Data Modification-Changing Data after it is inserted
• Transactions-Using transactions to maintain Database integrity
• PL/SQL-Using Procedural SQL to write simple "programs"
• Procedures-Storing PL/SQL which can be invoked as a function
• Views-Controlling how data is viewed
• Triggers-Using Triggers to maintain Database integrity