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 during the build operation.
Extension | Description |
|---|---|
Seq | Sequences |
Tbl | Tables |
Idx | Indexes |
Typ | Type |
Tps | Type spec |
Tpb | Type body |
Sql | Generic SQLs |
Pkh | Package use to 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 | Type spec |