5.12 PLVfk: Foreign Key Interface

Chapter 5
PL/Vision Package Specifications

 

---

The PLVfk (PL/Vision Foreign Key) package is a high-level, easy-to-use interface to look up foreign key information in your tables. See Chapter 19 for details.

5.12.1 Package Constants

c_prefix CONSTANT VARCHAR2(1) := 'P';

Specifies that the column abbreviation is to be used as a prefix.

c_suffix CONSTANT VARCHAR2(1) := 'S';

Specifies that the column abbreviation is to be used as a suffix.

c_no_change CONSTANT VARCHAR2(10) := 'NO CHANGE';

Used to indicate that no change is to be made to the string value.

c_int_no_change CONSTANT INTEGER := 0;

Used to indicate that no change is to be made to the INTEGER value.