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

Home -> Community -> Usenet -> c.d.o.server -> Re: can someone show some oracle sql stmt, I want to compare that with MYSQL in linux rh 9.0

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Sun, 10 Aug 2003 01:30:33 GMT
Message-ID: <3F359E32.7BB38CA@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.

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> Received on Sat Aug 09 2003 - 20:30:33 CDT