Databases Reference
In-Depth Information
Object Type
Object Type Suffix
Example
Comment
<Trigger
Details> TRG
FM USERS BIU TRG
(before insert or
update),
FM USERS AIUD TRG
(after insert,
update, delete)
or
USR AIUD TRG
(after insert, update,
delete)
Trigger
T
Type
New type, varchar2 array:
XLIB VC2 ARRAY T
V
View
View on the bookings:
FM BOOKINGS V
All database objects typically have their respective object type appended as a suffix with the
exception of tables and true API interfaces such as packages, procedures, functions, and synonyms.
The package names are always in singular form, for example, table
FM BOOKINGS
and package
FM BOOKING
. This is a personal preference and makes the code a little bit more readable and elegant, as
you can see in Listing 9-7 as opposed to Listing 9-6.
Listing 9-6.
Strict Enforcements of Naming Conventions
DECLARE
l res id NUMBER := 100;
BEGIN
----------------------------------------------------------
-- cancel all bookings for the selected ressource
----------------------------------------------------------
FOR cur IN (SELECT book id
FROM fm booking tab
WHERE book res id = l res id
AND book booked from > SYSDATE)
LOOP
fm booking pck.cancel booking prc (p book id => cur.book id);
END LOOP;
END;
Listing 9-7.
Naming Conventions with Exceptions
DECLARE
l res id NUMBER := 100;
BEGIN
----------------------------------------------------------
-- cancel all bookings for the selected ressource
----------------------------------------------------------
