Skip to content

Instantly share code, notes, and snippets.

View Dragonwolflord's full-sized avatar

Dragonwolflord

View GitHub Profile
@velppa
velppa / data_as_inserts.sql
Created December 30, 2012 08:45
This script exports data from tables as insert statements. Useful for exporting data from static dictionary tables. #oracle #sqlplus
set heading off
set linesize 1000
rem set pagesize 50000
set echo off
set serveroutput on
SET FEEDBACK OFF
SPOOL out.sql
DECLARE
cur SYS_REFCURSOR;