|
Pipelined table function
|
Platform:
|
Oracle 9i
|
Description:
|
The purpose of this document is to
provide an example of the new pipelined and parallel PL/SQL table functions available in Oracle9i.
View script |
|
Implement conditional unique constraint
|
Platform:
|
Oracle 8i,9i
|
Description:
|
This script enforces the next rule: cust_id have to be unique while status is active.
View script |
|
Function with variable parameters
|
Platform:
|
Oracle 8i,9i
|
Description:
|
This script creates a function with variable number of input parameters.
View script |
|
|