Archive for the ‘PLSQL’ Category

Explode function for pl/sql and hour changeing to minutes

Sunday, May 30th, 2010

First create the type with following query. CREATE OR REPLACE TYPE listtable AS TABLE OF VARCHAR2 (255); / This is the function to explode the string. For example we have 4:45 ':' is p_seperator and 4:45 is p_string and result of this function will be 285. CREATE OR REPLACE FUNCTION explode (p_seperator IN VARCHAR2, p_string IN VARCHAR2) ...