SEARCH


 


Oracle Functions

Convert

Convert Comma String to insert string

Rows

Rows to Columns Function

Bullet

Check for numerics in a Varchar2 field

Bullet

Count occurences of a string v2 - a lot better!

Bullet

Count occurences of a string v1

Bullet

Count characters in a string

Bullet

Using DBMS_UTILITY to analyze a schema

Delete Delete duplicate rows the faster way!
Bullet

Delete Duplicate Rows in a table

Bullet

Get the Directory name from a full path

Bullet

Get the directory path from a full path

Bullet

Get the filename from a full path

Bullet

Get the file suffix from a full file path

Bullet

Get just time portion from a date

Bullet

Get no. of weeks between 2 dates

Bullet

Get the file path when using MOD_PLSQL

Bullet

Test for Alphabetic Characters

Bullet

Test for Alphanumeric Characters

Bullet

Test for numeric characters

Bullet

Check XML file is well formed

Bullet

All about numeric for loops.

Bullet

Using a function to query a LONG