Home

Oracle PLSQL

 Tips, Tricks and Utilities  
  1. Function to remove symbols from a string
  2. Function to validate a date
  3. Function to validate a number
  4. Credit card validation based on LUHN algorithm
  5. U.S. Bank ABA number validation
  6. Format a Social Security Number
  7. Format a US Postal Code
  8. Function to count incidence of a specific char string
  9. Function to count the number of words in a string
  10. Function to return the phone number for a string of characters
  11. Function to strip extra spaces in a string
  12. PLSQL implementation of Lawrence Philips' Metaphone algorithm  See Also
  13. Send e-mail messages from PL/SQL with MIME attachments (Virgilio Nunes)
  14. Function that returns the words for currency (good for checks)
  15. Pre-Defined Exceptions for use in PL/SQL code (w/example)
  16. Error Stack Dump routine (writes to file)
  17. User Password Change routines
  18. UTL_FILE Load routine
  19. Word Wrap routine
  20. Simple if-then-else function for use in SQL
  21. Schema Template Code Generator.
  22. DBMS Job Control System
  23. Sample Advanced Queueing code
  24. Get Field from a delimited string of data
  25. Determine if the string has legible characters
  26. Random date generator, good for building test data!!
  27. Address Line clean-up routine
  28. Phone Number clean-up routine
  29. Alpha check utility
  30. Alpha check utility #2
  31. Encrypt Data Example
   
  Links to Other PL/SQL resources
 
  • DMOZ PL/SQL Directory (Search Site)
    		•

    FastCounter by bCentral
    1