...
| 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 PROCEDURE | /procedure | Each procedure must be ended by a '/' on its own line. | 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 | ||||
| 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 |
...