Query the Oracle data dictionary by issuing theSelect statement. Display the names of the columns bound by constraints by querying the data dictionary views. Match the SQL commands with their functions. Add new rows in a table by using a SQL command. Insert special values in a table by using the SQL functions.
Copy rows from a table by using a subquery.
Update existing rows in a table by using a SQL command. Update all rows in a table by using a SQL command. Delete rows from a table by using a SQL command. Identify the circumstances that ends a transaction. Identify when a transaction is controlled in Oracle7.