JAVA & SQL Automation

why not create a spreadsheet with a query per sheet ?

when they hit refresh in the sheet, the data gets reloaded.
Seems way easier

How to do that , As I am fresher in JAVA and SQL DB combination . Please share any samples

Also the final should be it should work as automated,, every day the team should the mail notification with the output what they are seeing in the spreadsheet.. Hope you have understood the req..
Let me know if you need more details.

there are many examples of how to connect excel to an oracle database

sample via lmgtfy:
http://bfy.tw/Grwa

there is no point for the mail
just open the spreadsheet and hit refresh

it is asking user name and password. Datasorce and Location
from where I can get this information..

from the same place you run your query ?

No this is not my requirment. Thanks for your help!!!
I am looking for a java script which can be helpful to write into the spreadsheet and send the mail to the team

Thanks
Venkatesh.

I'm not a Java person but if you can create a spreadsheet with one query, it should be a simple matter to add a loop to run through several queries and create a new sheet on each loop.

Since you say you are new to Java, where did the Java requirement come from?  Do you not have Java developers that work with you that can help?

I posted some .Net code back in 2013 that shows how to create a spreadsheet from table data.

Hopefully it can give you some ideas:
https://www.experts-exchange.com/questions/28225475/Best-way-to-export-to-excel-from-OracledataReader-in-c.html?anchorAnswerId=39450396#a39450396

Thank you NetMinder, But I am keenly looking for Javascript . becoz I can add this code into a scheduler by adding a mail to the code..  Hope you have understood. thanks much for sharing your thoughts.

Thanks
Venkatesh.

Java and JavaScript are two different things.

Not fully understanding but that is OK.  I don't have to.  You can schedule and email from just about any language.

If who can able to help on my requirent can help me to add the Mail notification at the end with the path where I am placing the output file is really helpful

Thanks
Venkatesh

This might be useful to you
https://www.experts-exchange.com/questions/28945335/How-do-i-send-mail-with-attachment-and-mail-body-will-have-some-data.html

If possible, please post your code and accept that so others may benefit from it.

As my own solution worked here rather than the suggestiong shared by the members