Target      CV      Scripts  Projects Download Contact
Welcome to Oracle Consulting Services - your data, your inspiration

 January 2005 
 December 2002 
 December 2001 
 June 2001 
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
 



© Copyright 2004.   All Rights Reserved.   Last updated on 01/02/2004