PL/Sql naming Conventions

PL/SQL Record type

When you create records with a structure you specify (rather than from a table or cursor), you must declare the type. Use a rectype suffix declaration as follows:

Scope	Type	Primary Identifier	Suffix	Example
Global		Account	rectype	g_account_rectype
Local		Account	rectype	account_rectype

Type of identifier

Type	Description	Example	Comment
k	Constant	k_mailhost	Generic constant
g	Variable	g_loop_count	Global (package-level) variable
v	Variable	v_loop_count	Local variable

File naming conventions

 

File Type	Extension
Package (spec, and optionally body)	pkg
Package Body	pkb
Procedure	prc
Function	fnc
Object type (spec, and optionally body)	typ
Object type body	tyb
Stored Java Procedure	sjp
Stored Java Function	sjf
Trigger	trg
Any other PL/SQL	pls
Any other SQL	sql

Some Other Important Conventions

PREFIX	PREFIX
V_	Varchar2
N_	Number
T_	Table
R_	Row
D_	Date
B_	Boolean