var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Oracle and excel
I'm able to create an excel sheet through pl/sql. I want to create new worksheets in the same excel file and generate reports accordingly. Does anybody has a clue please help me.
not pl/sql but Access
I do not know how to do it through Pl/SQL but I do through Microsoft Access. Connect to your Oracle db with a ODBC connection, use Acess to query the data you need. Then export that data to an excel spreadsheet.
If you really want to do Pl/SQL to excel. Look into Visual Basic. I know that with VB you can connect to the Oracle db, run your query (Pl/
SQL or SQL), then import the data into excel.
I don't know the exact code, but if should be fairly straight forward if you know how to program.
Thx very much for your reply.Using the sylk package we can create the excel sheet through oracle but I want three worksheets to be in one excel file that to created at run time