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

Hans Forbrich <forbrich_at_telusplanet.net> wrote in message news:3F359E32.7BB38CA_at_telusplanet.net...
> developer wrote:
>
> > can someone show some oracle sql stmt, I want to compare that with MYSQL
in
> > linux?
> > thanks!
>
> Look at http://otn.oracle.com/sample_code/content.html for some samples.
> Anything that starts with 'SELECT', 'INSERT', 'UPDATE' or 'DELETE' is a
SQL
> statement. While you are there, yo might want to search for the DDL on
'EMP,
> DEPT' and possibly check for 'schema definitions for SCOTT & HR' to help
> understand the table definitions.
>
> <soapbox>
>
> Just be aware, the way many developer work:
>
> - in a MySQL or PostgreSQL environment you typically a) write external
programs
> to interact with the database.
>
> - in Oracle you can: a) write external programs to interact with the
database;
> b) write 'internal' programs to work inside the database space; c) have
the
> external programs in 'a)' leverage these extension; d) extend the
database by
> leveraging these internal programs; e) have external programs leverage the
> extended database; and f) have the extended database interact with
external
> programs on it's own.
>
> So far I have not found how to easily replicate the extra Oracle
capabilities
> in MySQL or PostgrSQL. AFAICT most of the others sem to stop at 'c)'.
>
> </soapbox>

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.

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

( my first lanaguage is not english)
developer
>
Received on Sat Aug 09 2003 - 22:05:31 CDT