Database SQL file extensions and their order of process.

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 (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