Oracle Functions

Convert Comma String to insert string Rows to Columns Function Check for numerics in a Varchar2 field Count occurences of a string v2 - a lot better! Count occurences of a string v1 Count characters in a string Using DBMS_UTILITY to analyze a schema Delete duplicate rows the faster way! Delete Duplicate Rows in a table Get the Directory name from a full path Get the directory path from a full path Get the filename from a full path Get the file suffix from a full file path Get just time portion from a date Get no. of weeks between 2 dates Get the file path when using MOD_PLSQL Test for Alphabetic Characters Test for Alphanumeric Characters Test for numeric characters Check XML file is well formed All about numeric for loops. Using a function to query a LONG