Creating, Editing, and Dropping Schema Objects

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

Working with the Database