Run data manipulation statements (DML) to update data in the
Oracle Database 10g
Use the SET operators to create subsets of data
Create tables to store data
Utilize views to display and retrieve data
Create sequences to generate numbers
Obtain meta data by querying the dictionary views.
Identify the major structural components of Oracle Database 10g
Create reports of sorted and restricted data
Employ SQL functions to generate and retrieve customized data
Create reports of aggregated data
Write SELECT statements that include queries
Retrieve row and column data from tables with the SELECT
statement

Use SQL Statements to retrieve data from tables

Create and Manage Tables

Employ SQL functions to generate and retrieve customized data

Run data manipulation statements (DML) to update data in the

Oracle Database 10g