asimmon/oracle-sql-to-csv-raw-query.sql

Created November 20, 2015 15:10

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/asimmon/ca4134e371c3fb95a0c1.js"></script>
Save asimmon/ca4134e371c3fb95a0c1 to your computer and use it in GitHub Desktop.

Download ZIP

SQL query results to CSV using raw queries

Raw

oracle-sql-to-csv-raw-query.sql

	DECLARE
	v_csv CLOB;
	BEGIN
	SELECT query_to_csv('SELECT * FROM items') INTO v_csv FROM dual;
	END;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment