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 the build operation. property. This property is used to order populated files (partial 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 |
Seq
Sequences
Tbl
Tables
Idx
Indexes
Typ
Type
Tps