Are Oracle direct queries straightforward?

30 pts.
Tags:
Database Application
Microsoft Excel 2000
Microsoft Windows Server 2003
Oracle
Oracle Query
Hi, 
Our company uses an Oracle driven database application (java through internet explorer). 
At some point I can get reports in PDF for several predefined reports, but there isn't a way to retrieve the data from Oracle to an Excel spreadsheet, for easier post-processing. 
Is there any feasable way of connecting directly to the server and grab data to an excel file (with PHP for example)? Thanks in advance


Software/Hardware used:
Windows XP; Windows Server 2003; Apache+PHP; Oracle

Answer Wiki

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

write a query to desplay names and higher date of all the employee who where higher in the year 1985?

Discuss This Question: 9  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
  • Subhendu Sen
    Through PHP code, it may possible. Though I till date I do not experience it. But I am working in PHP currently. Here is a good Resource that may help u. After opening this site, click on "Example". Thanks--
    29,780 pointsBadges:
    report
  • carlosdl
    There could be many ways if you have the appropriate credentials, and the database can accept connections from the machine you are going to use to connect. With Oracle client software installed you could use SQL*Plus to run your queries directly, spooling your query's output to a CSV file.
    70,220 pointsBadges:
    report
  • Darryn
    Can you let us know why you state "there isn't a way to retrieve the data from Oracle to an Excel spreadsheet"? Is it due to internal decisions or software restrictions? You can work directly with databases through OLE Db in Excel.
    765 pointsBadges:
    report
  • Darryn
    Sorry, carrying on from previous, you can also use VBA to create your dataset, without the need for setting up DSNs, and "transform" the data before populating the spreadsheet (dependant on what you want to do).
    765 pointsBadges:
    report
  • Acseven
    Hi, thanks for your answers. I basically wanted to try and have the output data in excel format, to be able to work with it easaily. As I only have limited access to features, I don't know if I could do it directly from Excel. Thanks
    30 pointsBadges:
    report
  • jkeri
    We use Oracle10g forms the run Reports10g. The query in the report ends up as a CSV file , ready for use by Excel. Its not a difficult process to do. just create your query as a report. In the form, the REPORTS object is where you define the file and use the SET_REPORT_OBJECT_PROPERTY(v_rep_id,REPORT_DESFORMAT,'DELIMITEDDATA')
    360 pointsBadges:
    report
  • jkeri
    One way i did it was to use forms10g to call a reports10g. the report had the account for the rows i needed in the Excel file. My forms10g used the SET_REPORT_OBJECT_PROPERTY (v_rep_id,REPORT_DESFORMAT,'DELIMITEDDATA') and the SET_REPORT_OBJECT_PROPERT(v_rep_id,REPORT_DESNAME,'C:datadirectoryfilename.csv'); This created a file with the .CSV extension that was easily imported into Excel
    360 pointsBadges:
    report
  • orangehat
    Our head programmer says that Discoverer can do it and that's what we do. He builds an HTML that the end user can open. We run 10g App Server.
    1,745 pointsBadges:
    report
  • Acseven
    [...] Are Oracle direct queries straightforward? [...]
    0 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