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_EXTENSIONSproject property during . This property is used to order populated files (partial deploy) and to define the order in which they are sequenced in the build operation.
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 |