This tool / utility helps you export your data based on query resultset in the excel format.
 
java -jar oracle_xls_extract.jar
Picked up _JAVA_OPTIONS: -Djava.net.preferIPv4Stack=true
usage: Main
 -f,--jdbcfile      File path containing jdbc urls file format should
                         be
                         bmsd_dev1
                         jdbc:oracle:thin:@ftdcsoradbs01.ftdc.cummins.com:
                         1521:BMSD1
 -h,--help               show help.
 -j,--jdbcUrl       Database JDCB URL EX
                         jdbc:oracle:thin:@arlioradbs1.arli.cummins.com:15
                         21:prd1
 -o,--orausrpass    Database usermname/password with slash in oracle
                         format .. Use either (u and p )  or o
 -p,--password      Database Password
 -q,--query         SQL Query
 -r,--result        File Result output
 -t,--filetype      File Format / Type (CSV ,XLS)  Default : XLS
 -u,--username      Database UserName
USAGE :
  /usr/java6/jre/bin/java -jar $HOME/oracle_xls_extract.jar -u uname -p xx  -j jdbc:oracle:thin:@arlioradbs1.arli.cummins.com:1521:prd1  -q "select * from bms_preferences"
   /usr/java6/jre/bin/java -jar $HOME/oracle_xls_extract.jar -u uname -p xx-q "select * from bms_preferences"
         
Requirments : JRE 1.6 or above
You need a JDBC URL in the format  : 
jdbc:oracle:thin:@host.com:1521:SID
to connect with Oracle database.
Provide filename , username , password , and query you need your data to be extracted from and that's it .
You can also have list of jdbc urls stored in a file. Your query would run against all the databases listed in the file and you will get one combined file. This feature is very useful for having data extracted from multiple databases.
Download latest version from source forge .
https://sourceforge.net/projects/oracle-excel-extract/files/
Below are usage options. For help use -h : Ex java -jar Oracle_xls_extract.jar -h 
java -jar oracle_xls_extract.jar
Comments
Post a Comment
Please leave your relevant comments and questions only.