Tools
Debugging and
code-generating for routines containing parameters or variables of:
objects, records, scalar collections, composite collections.Debugging and
code-generating for routines containing parameters or variables of:
objects, records, scalar collections, composite collections.| I was going to
provide lots of screenshots showing how TOAD, SQL Navigator, Rapid SQL,
SQL-Station and PL/SQL Developer all handle LOBs, objects and collections.
But time was running short. I’ll have to leave the comparisons up to you. |
|
| If your PL/SQL
involves records and collections, you owe it to yourself to find a tool that
smoothly handles complex columns, types, attributes, parameters and return
types. This is especially true for generating test code, insert/update
statements and anonymous blocks. Such features could save you 50-60% of your
coding time. If your tool does not do these things, demand enhancements from
your tool vendor. |
|
| Here are some
sample types, objects, tables and test code… |