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