-
exporting data from pl/sql to excel
Hi,
is there any way i can directly export data from a PL/SQL block to an Excel file
I tried using utl_file utility but it didn't work
-
You could export the data to a text file (using UTL_FILE) and then import the text file manually in Excel (either fixed length or demilited option).
Cheers!
OraKid.
-
SQL to Excel Template
Hi there,
I would like to know the procedure of automatically filling out a template with the information that is in SQL.
I have a new template in Excel and I want to map the cells to the values from SQL. How would that be accomplished?
I would appreciate the information
Thanks
Sharjeel
-
try using this with the help of TOAD.
U will get such a option in toad.
-
-
Hello,
there is great Oracle PL/SQL package ORA_EXCEL which can produce Excel xlsx files from an Oracle database using only PL/SQL.
It is easy to use this package, one simple example code that generates Excel file:
BEGIN
ORA_EXCEL.new_document;
ORA_EXCEL.add_sheet('My Sheet');
ORA_EXCEL.add_row;
ORA_EXCEL.set_cell_value('A', 'Hello World!');
ORA_EXCEL.save_to_file('EXPORT_DIR', 'example.xlsx');
END;
More details you can find on www.oraexcel.com
Greetings
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|