How to retrieve data from table using its key?

View current SQL table data witout using applications or exporting.?

  • I'm using Oracle 10G and Sql Developer. I need to figure out a way to view the data within a specific table, without using SQL Developer or using exports. I created a report for the data set i'm trying to make available, but i connot figure out how to view that report outside of the oracle application.. if that's even possible. You can create an export of the table into html. That format would be ideal, but only the current data is exported. As the table is updated, more exports would need to be ran and i do not want to run an export 20 times a day. I've looked into automated exports and i know mysql has that functionality, but i dont think Oracle does. All i need is a simple way to SELECT * FROM TABLE; I wonder if this can be done from a batch file.

  • Answer:

    Oracle would have to be running as a service. Then you could connect with it using any programming method you please (PHP, C#, Visual Basic, Crystal Reports, etc.), execute your query and view the results.

newtrara... at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

Let me make sure I understand. You have a database where data is being constantly updated during the day. Then you need a report on some of that data to be made available to users. But you do not want to write any application for that ? Not even a simple web application that your users would access to get an up to date report ? So you are thinking about making that report available in some automated mode, and user would then access this report. That approach obviously then requires some automated way to produce the report, put it somewhere and let users grab it from that "somewhere". There are three aspects to that problem: 1) How to automate the production of the report. You can do that using a simple shell script that (for Oracle) invokes SQLPLUS and calls the proper SQL statements or PL/SQL procedure to produce the report and save it somewhere on disk. Make sure that script is run at regular intervals according to your needs (like every hour) using simple schedulin (cron jobs on unix, "at" on windows). Another way is to use the scheduler of the Oracle database (DBMS_SCHEDULER) and have the database drive the process. 2) How to make the report available to the users: that all depends on who the users are and how they are connecting to your servers. You could just place the report in some shared disk and give users shared access to that shared area (like a shared network drive on windows or a nfs-mount on Unix). If your users are external, then the simplest is to use a web server: just publish the report as an html page and send the URL to the users. Or you could also make it available via an ftp server. 3) How to notify the users that a new report is available. You can make the script that produces the report send an email to the interested users. Then again, you could then just send the whole report by email. Sending email is again easily done from the Oracle database. Note that obviously the report will never show the accurate real-time state of our data since it will be produced at regular intervals.

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.