A collection of reusable code, programs, and database objects that provides common functionality across all E-Business products.
File Extensions
If file is not Concurrent program (indicated by parent folder), then it is considered DB Objects (SQLs). File content is also further analyzed by populate process.
...
Tip |
---|
Make sure to end file with forward slash /, if last statement is Package, Trigger etc. Simple statements can be delimited by ; otherwise you need forward slash. Single or multiple line comments are also supported in input files. |
Code Block | ||||
---|---|---|---|---|
| ||||
DROP TABLE HR.DEPARTMENTS; CREATE TABLE HR.DEPARTMENTS ( DEPARTMENT_ID NUMBER (4) NOT NULL , DEPARTMENT_NAME VARCHAR2 (30 BYTE) NOT NULL , MANAGER_ID NUMBER (6) , LOCATION_ID NUMBER (4) ); DROP SEQUENCE HR.DEPARTMENTS_SEQ; CREATE SEQUENCE HR.DEPARTMENTS_SEQ INCREMENT BY 10 MAXVALUE 9990 MINVALUE 1 NOCACHE; CREATE OR REPLACE TRIGGER HR.ID_DEPARTMENTS BEFORE INSERT ON HR.DEPARTMENTS FOR EACH ROW BEGIN SELECT HR.DEPARTMENTS_SEQ.NEXTVAL INTO :new.DEPARTMENT_ID FROM dual; END ID_DEPARTMENTS; / |
...