- Control database access to specific objects
- Manage schema objects and use data dictionary views
- Manipulate large data sets in the Oracle database by using subqueries
- Manage data in different time zones
- Retrieve data by using advanced subqueries
- Use the regular expression support in SQL to search, match, and replace strings in terms of regular expressions
- Retrieve row and column data from tables with the SELECT statement
- Create reports of sorted and restricted data
- Display data from multiple tables.
- Use DML statements to manage data.
- Use DDL statements to manage database objects
- Create reports of sorted and restricted data
- Run data manipulation statements (DML) to update data
- Control database access to specific objects
- Manage schema objects
- Manage objects with data dictionary views
- Retrieve row and column data from tables
