Create, edit, or drop (delete from the database) a variety of online and offline database schema objects:
|
Object
|
Create
|
Edit
|
Drop
|
|---|---|---|---|
| User name | Creating Users | SQL Worksheet | SQL Worksheet |
|
Functions (PL/SQL) |
Creating PL/SQL Functions | Editing PL/SQL Programs | Dropping Schema Objects |
| Java Classes | N/A | N/A | N/A |
| Materialized View Logs | SQL Worksheet | SQL Worksheet | SQL Worksheet |
| Materialized Views | SQL Worksheet | SQL Worksheet | SQL Worksheet |
| Object Types | SQL Worksheet | Editing Other Database Objects | Dropping Schema Objects |
| Packages and Package Bodies | Creating PL/SQL Packages | Editing PL/SQL Programs | Dropping Schema Objects |
| Procedures | Creating PL/SQL Procedures | Editing PL/SQL Programs | Dropping Schema Objects |
| Sequences (online and offline) | Creating Sequences | Editing Sequences | SQL Worksheet |
| Synonyms (online and offline) | Creating Synonyms | Editing Synonyms | SQL Worksheet |
| Tables (online and offline) | Creating Tables | Editing Tables | Dropping Schema Objects |
| Triggers | Creating PL/SQL Triggers | Editing PL/SQL Programs | Dropping Schema Objects |
| Views (online and offline) | Creating Views | Editing Views | SQL Worksheet |
Copyright © 1997, 2004, Oracle. All rights reserved.