ravgopal

 Profile Answers by ravgopal 

• Oct 10th, 2007

 

Question is not clear. 

Do you want to read from an XL sheet using PL/SQL?

kashyap_aseem

 Profile Answers by kashyap_aseem 

• Feb 7th, 2008

 

can we store the result obtain from  query in excel sheet
if yes then how ?

if suppose rows returned is more then 1 lacs? then ?

binurajnair

 Profile Answers by binurajnair 

• Feb 20th, 2008

 

Using utl_file you can write to a flat file. Create a .xsl file and write in Excel format. Please note that the file will be created in the server machine only.

dhrj020578

 Profile Answers by dhrj020578 

• Mar 3rd, 2008

 

We can use OLE objects (Built in) to write to an Excel Sheet (XLS). We can create a CSV file with UTL_FILE but not an XLS file.

rudhra97

 Profile Answers by rudhra97 Questions by rudhra97

• Jul 24th, 2008

 

by using sql*loader tool,we can convert flat files into oracle tables

rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Aug 12th, 2008

 

By using SQL LOAER, TOAD we can insert EXCEL file data into respective Table & we can also create or upload ORACLE table data to .xls file from that.

Thanks
Rajiv Gupta
Yogik Technologies Pvt. Ltd.