Home > IT Answers > Oracle > export data from forms to excel
Brithivi
5 pts.
 export data from forms to excel
PL/SQL, SQL
how to export the selected data from forms to excel?..

Software/Hardware used:
ASKED: July 30, 2009  6:55 AM
UPDATED: October 9, 2009  4:02 PM
RELATED QUESTIONS
Answer Wiki:
Create a view with the filter conditions. Then export the data using export command. --------- jjohannsen I know of a product that installs as a storedproc in the database that can take a cursor or SQL select statement and deliver a CLOB back in an XML file format that opens natively in MS Excel. I am using it on a project right now, and our users are loving it. <a href="http://www.peak42solutions.com">www.peak42solutions.com</a>
Last Wiki Answer Submitted:  October 9, 2009  4:02 pm  by  Jjohannsen   290 pts.
All Answer Wiki Contributors:  Jjohannsen   290 pts. , Mraman   260 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

What version of forms are you using ?
The answer could be completely different depending on that.

carlosdl
 63,535 pts.
 

The export utility won’t export the data in excel format. The file generated with EXPORT can only be used to import with the IMPORT utility.

carlosdl
 63,535 pts.