Re: can someone show some oracle sql stmt, I want to compare that with MYSQL in linux rh 9.0

developer wrote:

>
> normally I write php and use dbtools to interact with mysql table. I have
> not use oracle before.
>
> q1. is there any version of oracle suitable for installation in rh 9.0 ( the
> server is co-location) and I have server with similar capacity at home for
> testing.

You can download the latest version of Oracle free-of-charge from http://otn.oracle.com. I strongly encourage using the latest version as the older ones will all be out-of-full-support soon.

The latest version is Oracle9i Release 2. It is suitable for rh AS-2.1 and other certified combinations (as well as Windows, every unix that matters, etc.). People have tried to install on rh9 and there seem to be some install headaches - suggest you web-search on 'oracle install red hat'

>
> q2. what is the external language for interact? ( the external language in
> web-based is php) then apache to do the web -based programming.

I suspect you are in for a bit of a learning curve. Please look at the sample code and the documentation areas of http://otn.oracle.com. I strongly encourage you to read chapters 1-3 of the Oracle Concepts Manual found in the documentation section (http://otn.oracle.com >> documentation >> database >> version >> view >> list all books >> Concepts)

Please note that the database comes with a built-in Apache web server and that server has a number of mods that are very useful to working with Oracle. Also note these mods are not easily moved to other versions of Apache.

There are a number of FAQs around - web-search ORACLE FAQ and check them out. Received on Sat Aug 09 2003 - 23:32:20 CDT