PL/SQL “Do’s” 9 & 10
uUse
implicit cursors when appropriate
ØMarginally faster than explicit cursors for single record fetches.
ØMake
code easier to read.
ØCursor is defined right where it is executed.
ØImplicit cursors raise the exceptions NO_DATA_FOUND
(only the first fetch is null)
and TOO_MANY_ROWS.
uDates are numbers
ØInternally in Oracle, dates are really numbers
§Can perform numeric operations against dates.
§Oracle 9i and 10g have new datatypes
to store dates:
§TIMESTAMP and INTERVAL
