Oracle help :(

dominant

I want to learn the sql syntax of the Oracle in order to make my own php-Oracle application.

Any help?

pete_bisby

I've used Oracle SQL in the past, and I have to say that there isn't much difference between the structure of Oracle SQL and MySQL SQL.

If you already have some knowledge of MySQL, then there shouldn't be much of a problem migrating to Oracle.

You do have greater flexibility with Oracle, though, especially with the ability to create references and relationships between tables, and able to create sub-queries, which can be a great help with larger, more complex queries.

All I can suggest is get used to writing SQL queries using the Oracle interface first before trying to write SQL queries embedded within PHP. Oracle can be quite strict, so you must first familiarise yourself with the error messages that will "definitely" appear.

Have a look on the web-sites for some Oracle SQL tutorials - there are plenty to choose from.

dominant

I have already installed the Oracle 9i r2 but i dont know how to configure it in order to cooperate with php and apache, as well.

I use the SQLPlus to make some queries.

dominant

any ideas?

pete_bisby

Have a look at the following PHP manual page, and see if this can put you in the right direction. This page also has posts from other people who have installed Oracle for use with PHP.

http://www.php.net/manual/en/ref.oci8.php