invite friends  Invite Friends RECRUITER : Login | Register | Post Job | Search Resume   
Forum
Home >> Oracle SQL >> General PL/SQL Scripts
Add New   General PL/SQL Scripts
William Hill
Mon Aug 02, 2010
Update/ delete from a huge table with intermittent commits - http://www.orafaq.com/scripts/plsql/plsloop.txt






Select records from a cursor into PL/SQL table - http://www.orafaq.com/scripts/plsql/plstable.txt






Password encrypt/decrypt using DBMS Obfuscation Toolkit - http://www.orafaq.com/scripts/plsql/password.txt






Pass result sets (REF CURSOR) between procedures and functions - http://www.orafaq.com/scripts/plsql/refcurs.txt






Random number/ string generator package - http://www.orafaq.com/scripts/plsql/random.txt






# Function to test for Leap Years - http://www.orafaq.com/scripts/plsql/leapyear.txt






Send e-mail messages from PL/SQL (using UTL_TCP) - http://www.orafaq.com/scripts/plsql/smtp.txt
William Hill
Mon Aug 02, 2010
Refer - http://www.orafaq.com/wiki/Scripts