Convert String to Array / List in PL/SQL

CREATE OR REPLACE PACKAGE parse /* Generalized delimited string parsing package Author: Steven Feuerstein, steven@stevenfeuerstein.com Latest version always available on PL/SQL Obsession: www.ToadWorld.com/SF Click on “Trainings, Seminars and Presentations” and then download the demo.zip file. Modification History Date Change 10-APR-2009 Add support for nested list variations Notes: * This package does not validate correct use [...]

How to exit from a procedure in Oracle

To exit from function is easy, just put “RETURN” CREATE OR REPLACE FUNCTION MIS.FC_GET_ACCRUAL_COM(VAGR IN VARCHAR2) RETURN NUMBER IS VNUM NUMBER; BEGIN SELECT AGR INTO VNUM FROM TAGR WHERE AGR = ‘AA’; IF VNUM = 0 THEN RETURN 1; ELSE RETURN 2; END IF; RETURN VNUM; EXCEPTION WHEN OTHERS THEN RETURN 0; END; / To [...]

Generate Insert Statement Script to Extract Data from Oracle Table

Here, you can use the following code to generate insert statement to extract the existing data from an oracle table. The generated script can be run at a later time to re-create your data. The code handles only date, char, varchar2, and numeric data types. I got this code from googling, original version by Ashish [...]