Managing Database Objects in Oracle Database 10g
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Overview/Description
To demonstrate how to create external tables and to use the data dictionary views in Oracle 10g
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with RDBMS technologies and programming techniques
Expected Duration (hours)
1.8
Lesson ObjectivesManaging Database Objects in Oracle Database 10g
create external tables and identify how to query them.
create and query external tables in Oracle 10g.
view information about user objects, tables, and columns using data dictionary views.
query the dictionary views for object, table, and column information.
view information about constraints, views, sequences, synonyms, and comments using data dictionary views.
query the data dictionary view for information about constraints, views, sequences, synonyms, and comments.
Course Number:223296_eng