Re: Oracle Tools - Which one(s)?

> As a newcomer to Oracle work, I am confused by the many different
> product offerings.
>
> What I have to do is take an existing xbase database and put it on the
> web, providing several different web pages to do very customized
> searches. The web page development will probably be done in Java. The
> database will ultimately be hosted on a web server running Oracle 7 or
> 8, but during development I need a product to run on my desktop computer
> (Windows95 or WindowsNT) to allow me to translate/transfer the xbase
> data to new/modified Oracle tables via ODBC, and to test the web pages I
> am developing.
>
> Do I need Personal Oracle, Oracle Lite, Oracle Power Objects Pro, Oracle
> Power Objects Client/Server, Oracle Database Designer, . . .
>
> Thanks in advance for any assistance.

Hi

what you need is Oracle8 or Oracle7.* with the Web Application server probably on an NT platform.
I personally would not use java to do the web searches because of the overhead of downloading java apps ,incompatablility beween various browsers and relative difficulty of writing java apps. The best bet is to use the PL/sql cartridge that comes with the web application server to write native sql procedures for oracle, it is a relativly simple language to learn. And the results will be vanilla HTML which fast and friendly to all browsers.

To import and export data your best bet is to use Microsoft access. With Oracle8 and access you can export via ODBC ,I had problems exporting via ODBC with Oracle 7.3.2.1.1.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 16 1998 - 01:29:52 CDT