|
|
| |
 |
|
Putting Methods to
Work in Oracle
Oracle Tips by Mike Ault |
Method Basics
Oracle has included a number of extensions to
SQL to support the creation and administration of the object
features, not the least of which are methods. Methods must be
declared as PL/SQL objects but a method definition may, in turn,
call any program accessible by the C language. Oracle8 currently
supports four different types of methods: constructor,
map, order, and user defined.
A constructor method is a
function that creates a user defined object based on the definition
stated in the object type's specification. Oracle names the new
constructor method the same name as the new object type. The
parameters are the same as the attributes named in the object type
definition. From the standpoint of method execution, think of the
use of the object type name as the invocation of the constructor
method.
SEE CODE DEPOT FOR FULL SCRIPTS
 |
If you like
Oracle tuning, you may enjoy the book
Oracle Tuning: The Definitive Reference
, with over 900 pages of BC's favorite tuning tips &
scripts.
You can buy it directly from the
publisher and save 30%, and get instant access to the code
depot of Oracle tuning scripts. |
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
|
|
|
