Skip to content

Instantly share code, notes, and snippets.

@asimmon

asimmon/oracle-sql-to-csv-cursor.sql

Created November 20, 2015 15:09
Show Gist options
  • Save asimmon/435acb8ec789cb6c1d3f to your computer and use it in GitHub Desktop.
Save asimmon/435acb8ec789cb6c1d3f to your computer and use it in GitHub Desktop.
Download ZIP
SQL query results to CSV using cursor
Raw
oracle-sql-to-csv-cursor.sql
DECLARE
v_items_cursor SYS_REFCURSOR;
v_csv CLOB;
BEGIN
OPEN v_items_cursor FOR
SELECT * FROM items;
v_csv := cursor_to_csv(v_items_cursor);
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment