Archive for the 'Oracle' Category

Removing numbers from a string

• July 17, 2008 • Leave a Comment

Posted in Oracle, PL/SQL


Create functions to join and split strings in SQL

• March 2, 2008 • Leave a Comment

Posted in Oracle, PL/SQL


Another way of manipulating large amount of data in oracle (Remove duplicate)

• January 30, 2008 • Leave a Comment

Posted in Oracle, PL/SQL


Insert and by pass unique constraint

• November 13, 2007 • Leave a Comment

Posted in Oracle


Update and Select in oracle

• November 13, 2007 • Leave a Comment

Posted in Oracle, PL/SQL


Malaysian NewIC validate function in PL/SQL

• March 1, 2007 • Leave a Comment

Posted in Oracle, PL/SQL


Loading data into non-empty table

• February 13, 2007 • Leave a Comment

Posted in Oracle


About SQL*Loader / Oracle Bulk Loader beginning

• February 13, 2007 • Leave a Comment

Posted in Oracle


Finding the latest / max records in transactional table

• February 10, 2007 • Leave a Comment

Posted in Oracle, PL/SQL, SQL