Database SQL file extensions and their order of process.
- Karl Henselin
Here are the SQL extensions and their types. The plugin deploys these files in the below order. These extensions are general practice and not mandatory. You can use other extensions and can override the sequence of these files by providing a value for the FDEBS_SQL_EXTENSIONS project property. Â This property is used to order populated files (package-based deploy) and to define the order in which they are sequenced in the build.
Extension | Description |
|---|---|
seq | Sequences |
tbl | Tables |
idx | Indexes |
typ | Type |
tps | Type spec |
tpb | Type body |
sql | Generic SQLs |
pkh | Package used for accessing from Oracle-compatible database |
plb | PL/SQL binary |
pks | Package source |
pkb | Package body |
pls | PL/SQL Source |
pck | Combined package spec plus body |
fnc | Function |
trg | Trigger |
spc | Package Spec |
bdy | Package body |
prc | Procedure |
Â
- style