xml - Oracle - Automate Export/Unload of Data -


oracle sql developer has option export contents of query result various formats (csv/fixed width/excel/xml). there way automate it?

if not, free tools available let me automate exports same formats sql developer capable of exporting to?

i don't know of way automate sql developer exports, no.

however, it's easy enough generate csv and/or fixed width files pl/sql (using utl_file package). tom kyte has example of programs generate csv or fixed width files using either pl/sql or pro*c. either can relatively automated using favorite scheduler.

xml outputs can automated in same way depending on how control need on xml generated. if need valid xml , don't care format of xml, can using dbms_xmlgen package (this example straight documentation).

declare   qryctx dbms_xmlgen.ctxhandle;   result clob; begin   qryctx := dbms_xmlgen.newcontext('select * hr.employees');   -- set row header employee   dbms_xmlgen.setrowtag(qryctx, 'employee');   -- result   result := dbms_xmlgen.getxml(qryctx);   insert temp_clob_tab values(result);   --close context   dbms_xmlgen.closecontext(qryctx); end; /

you write result clob file using utl_file and, again, use favorite scheduler schedule it.

if need generate file excel can open, need create csv or tab-delimited file. excel can open either type of file relatively though step of being prompted accept delimiter found (it detects delimiter correctly).

generating native excel output bit more challenging. there pl/sql apis generating excel files such jason bennett's exceldoctypeutils. i've gone java stored procedure used either jexcelapi or apache poi generate excel file. this, obviously, requires bit more work implement. once have stored procedure can write excel file, other options, can automate calling procedure using favorite scheduler.


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more