export data from forms to excel

5 pts.
Tags:
PL/SQL
SQL
how to export the selected data from forms to excel?..

Answer Wiki

Thanks. We'll let you know when a new response is added.

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>

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    What version of forms are you using ? The answer could be completely different depending on that.
    68,525 pointsBadges:
    report
  • carlosdl
    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.
    68,525 pointsBadges:
    report
  • Babasuthakar
    please help excel to from oracle and forms to excel ,whatever import and export coding ,
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following