20 July 2016

Oracle SQL Developer : Formatting Query Results to CSV/xml/html/json

Add hint to sql in the below format to get custom and run in execute mode (F5)

SELECT /*csv*/ * FROM scott.emp;
SELECT /*xml*/ * FROM scott.emp;
SELECT /*html*/ * FROM scott.emp;
SELECT /*delimited*/ * FROM scott.emp;
SELECT /*insert*/ * FROM scott.emp;
SELECT /*loader*/ * FROM scott.emp;
SELECT /*fixed*/ * FROM scott.emp;
SELECT /*text*/ * FROM scott.emp;
SELECT /*json*/ * FROM scott.emp;

or

SET SQLFORMAT csv
SET SQLFORMAT json

2 comments:

Oracle Fusion said...

Reading this blog I feel comfortable I got important information about Oracle SQL Develope. Keep posting more blogs on oracle.
Oracle R12 financials online training

ERP said...

We are ERPTREE Leading oracle fusion HCM Online Training institute. We are providing online training services since 1999. still we are adding more oracle related courses as the technology changes. 2000+ online courses are available. we all ways achieve our goal in satisfying students in result we have global recognition to our site. we have best faculty for all of our online courses.



Oracle Fusion HCM Online Training