Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 operationproperty.  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

seq

Sequences

Tbl

tbl

Tables

Idx

idx

Indexes

Typ

typ

Type

Tps

tps

Type spec

Tpb

tpb

Type body

Sql

sql

Generic SQLs

Pkh

pkh

Package

use to

used for accessing from Oracle-compatible database

Plb

plb

PL/SQL binary

Pks

pks

Package source

Pkb

pkb

Package body

Pls

pls

PL/SQL Source

Pck

pck

Combined package spec plus body

Fnc

fnc

Function

Trg

trg

Trigger

Spc

spc

Package Spec

Bdy

bdy

Package body

Prc

prc

Procedure

Seq

Sequences

Tbl

Tables

Idx

Indexes

Typ

Type

Tps

Type spec