| |
Schema
- XXAAA_CNV: Conversion Schema
- XXAAA_EXT: Extensions and Modifications Schema
- XXAAA_INT: Interface Schema
Database Object Naming Conventions.
- XXAAA_INV_TABLE_NAME : First segment is the custom extension, second segment is the module name, and the rest or short description. The tables will be with the file
extension tbl. Include the grants to the other schemas in this tbl script. Synonym names will be as same as *.tbl file name, but with the extension *.syn
- XXAAA_INV_TABLE_NAME_U1: Unique index Sequence 1. The index file names will be ending with the extension idx
- XXAAA_INV_TABLE_NAME_N1: Non-Unique index Sequence 1
- XXAAA_INV_Package_Body: Package specification files stored with the extension pks, and the body stored with extension pkb. The utility files ends with _UTIL, public
package ends with _PUB, and private package ends with _PVT
- XXAAA_INV_Description.sql: SQL File for Concurrent programs.
- XXAAA_INV_TABLE_NAME_SEQ.seq: Sequences created as close to the table name ends with SEQ. File extension is .seq
- XXAAA_INV_TABLE_NAME_V.view: If the view is not based on multi language. The file extension for all the view creating scripts are .view
- XXAAA_INV_TABLE_NAME_VL.view: If the view is based on multi language.
- XXAAA_INV_TABLE_NAME_MV(L).view: Materialized View or multi language materialized view.
Variables inside the code are prefixed with "g" for global variables, and "lg" for local global variables, and "l" for local variables.
The second character "v" for varchar2, "n" for number, "i" for integer, "d" for date, "b" for boolean, "t" for table, "r" for row type.
In case of using constants, the third character "c" can be used.
Below are few examples.
- gv_transaction_allowed
- lgvc_my_profile_value
- lv_my_varchar_value
- lt_table_type_value
- lvc_my_constant_value
LDT File Naming conventions
- XXAAA_INV_Description_MSG: Message
- XXAAA_INV_Description_PROF: Profile option, and its values
- XXAAA_INV_Description_CONC: Concurrent Programs
- XXAAA_INV_Description_DT: BI Publisher Data Template
- XXAAA_INV_Description_DD: BI Publisher Data Definition
- XXAAA_INV_Description_RS: Request Sets
- XXAAA_INV_Description_RSL: Request Set Links
- XXAAA_INV_Description_RG: Request Groups
- XXAAA_INV_Description_PERS: Personalization
- XXAAA_INV_Description_FRM: Form Definition
- XXAAA_INV_Description_FUN: Form Function Definition
- XXAAA_INV_Description_MENU: Menu
- XXAAA_INV_Description_RESP: Responsibility
|