Access a table into Oracle server

Jose Rivas · 03-31-2015, 03:02 PM

Hi there linuxfans, I have Fedora 12 -but can install another distro- and I want to access a Oracle 11g server -another machine same lan- and display in web browser the contect of a single SQL query into a table, for example

select vendor, sum(sales) from salenc group by vendor

Is there a option in webserver to link the Oracle db/table?

TB0ne · 03-31-2015, 03:24 PM

Quote:

Originally Posted by Jose Rivas

Hi there linuxfans, I have Fedora 12 -but can install another distro- and I want to access a Oracle 11g server -another machine same lan- and display in web browser the contect of a single SQL query into a table, for example

select vendor, sum(sales) from salenc group by vendor

Is there a option in webserver to link the Oracle db/table?

Many options. First, though...Fedora 12 is ANCIENT, and you really need to use something current. But the distro is irrelevant, since you're asking about how to connect to an Oracle database server through a web page. This can be done with PHP, Java, Ruby, and many other methods as well. Putting in "how to connect to an oracle database through a web page" into Google pulls up over ELEVEN MILLION results...have you looked at ANY of them??? The first two are from Oracle themselves:
http://www.oracle.com/webfolder/tech..._db/php_db.htm
http://docs.oracle.com/cd/B28359_01/...htm#TDPNG00000

Jose Rivas · 04-02-2015, 11:36 AM

Java looks great, this is the first to evaluate.

TB0ne · 04-02-2015, 01:35 PM

Quote:

Originally Posted by Jose Rivas

Java looks great, this is the first to evaluate.

Java would be the LAST thing to evaluate, in my opinion. Both PHP and Ruby are MUCh easier to implement. But,that's up to you...you still don't say what you're trying to do, or give us any details, so it could be that java is the better way to go.