...
| Object Type | Packaging Folder | Archived? | Notes | |
|---|---|---|---|---|
| CREATE/ALTER/DROP DATABASE LINK | /sql_direct | Yes | ||
| CREATE/ALTER/DROP FUNCTION | /function | No | Each function must be ended by a '/' on its own line. | |
| CREATE/ALTER/DROP INDEX | /ddl /ddl_direct /sql_direct | Yes | ||
| CREATE/ALTER/DROP QUEUE | /sql_direct | Yes | ||
| CREATE/ALTER/DROP SEQUENCE | /ddl /ddl_direct /sql_direct | Yes | ||
| CREATE/ALTER/DROP PUBLIC SYNONYM | /sql_direct | Yes | Alternatively, use Datical Auto-Synonyms | |
| CREATE/ALTER/DROP | SYNONYMPUBLIC SYNONYM | /ddl /ddl_direct /sql_direct | Yes | AlternativelyAlternatively, use Datical Auto-Synonyms |
CREATE/ALTER/DROP TABLE | /ddl /ddl_direct /sql_direct | Yes | ||
| CREATE/ALTER/DROP GLOBAL TEMPORARY TABLE | /ddl /ddl_direct /sql_direct | Yes | ||
| CREATE/ALTER/DROP MATERIALIZED VIEW | /sql_direct | Yes | ||
| CREATE/ALTER/DROP PACKAGE | /package | No | Each package must be ended by a '/' on its own line. | |
| CREATE/ALTER/DROP PACKAGE BODY | /packagebody | No | Each package body must be ended by a '/' on its own line. | |
| CREATE/ALTER/DROP PROCEDURE | /procedure | No | Each procedure must be ended by a '/' on its own line. | |
| CREATE/ALTER/DROP TRIGGER | /trigger | No | Each trigger must be ended by a '/' on its own line. | |
| CREATE/ALTER/DROP TYPE | /sql_direct | Yes | Each type must be ended by a '/' on its own line. | |
| CREATE/ALTER/DROP VIEW | /view | No | ||
| CREATE/ALTER/DROP VIEW INDEX | /ddl /ddl_direct /sql_direct | Yes | ||
| CREATE/ALTER/DROP CURSOR | /sql_direct | Yes | ||
| CREATE/ALTER/DROP DIRECTORY | /sql_direct | Yes | ||
| RENAME <DB_OBJECT> | /sql_direct | Yes |
...