free Oracel/SQL compiler

[e***@gmail.com]

I need to download free compilers for Oracle and SQL to teach my self .
Is there any minimum of windows or Solaris requirements ?

[HansF]

Post by e***@gmail.com
I need to download free compilers for Oracle and SQL to teach my self .
Is there any minimum of windows or Solaris requirements ?

Before you start with that, I strongly encourage you get a better handle
on some of the basic terminology. Two recomended books before you
download anything from ORacle:

1) Oracle Essentials (from O'Reilly books)
http://www.oreilly.com/catalog/oressentials3/

2) Oracle's online Concepts manual - at least chapter 1
http://otn.oracle.com/pls/db10g/portal.portal_demo3?selected=1
(and see the 'Getting STarted' section)

After that, you can read the Quick Installation guide for the operating
system of your choice - same page - to get an idea of system requirements
and minimums.

<please consider>
For your sake, and ours, please don't skip the reading. Skipping the
Concepts manual will only cause everyone frustration.

I know you are really smart and can learn this on your own, but there
really is a reason that the official Oracle documentation is over 55,000
pages ... it is complex.
</please consider>

Then, once you have Oracle installed, get yourself down the right
development path by reading and following the examples in Thomas Kyte's
"Effective Oracle by Design"

Also: cross posting to the entire comp.database.oracle.* heirarchy
really is not necessary as the same people tend to read and respond.

You refer to SQL ... from the post, I assume you mean MicroSoft SQL
Server. I also encourage you to have the same respect for the Microsoft
product and community by spending at least a little bit of time trying to
understand some concepts before using that.

<observation>
SQL is a language, not Microsoft's product. Using the abbreviation for
Microsoft's product usually is an indication of newbies mistakenly trying
to impress people. OR a SQL Server pro discussing the product with other
SQL Server pros in a situation where the term can not be confused.
</observation>

Finally - realize that there are enough differences that the two products
should be learned separately. Attempting to learn both at the same time,
or attempting to switch from one to the other without learning the
difference, will cause you and us horrible frustration. Not the least of
which being overloaded terminology - same term meaning diferent things.

[Billy]

Post by e***@gmail.com
I need to download free compilers for Oracle and SQL to teach my self .
Is there any minimum of windows or Solaris requirements ?

Okay, so you download let's say the Pro*C precompiler for C++. Great.

Now what do you do with it? To use it, write code that uses Oracle SQL,
you need an Oracle instance.. correctly installed, correctly
configured, with a database.. You need to know basic Oracle concepts.
Developer fundementals. The diference between SQL and PL/SQL. What
partitioning is, an index-organised table, bind variables and a whole
whack of other stuff.

So don't you jump in feet first without using the grey stuff first.
This sure ain't jumping into 1ft of water in a blow-up pool to play
with a yellow rubber duckie. This is an ocean with real fish, lots of
water, and everything from glassy clear tropical water to raging ocean
storms.

Go to tahiti.oracle.com, subscribe (for free) and read the Oracle
Concepts Guide. Followed that with the Oracle Application Developer
Fundementals.

Then jump.

--
Billy

[DA Morgan]

Post by e***@gmail.com
I need to download free compilers for Oracle and SQL to teach my self .
Is there any minimum of windows or Solaris requirements ?

Please do not cross-post to every usenet group you can spell.

There is no such thing as a SQL compiler as SQL is not a compiled
language. Also you have posted to usenet groups for two different
products. Please define what it is you are actually doing, or trying
to do, and you might get back useful information.

[Volker Hetzer]

Post by e***@gmail.com
I need to download free compilers for Oracle and SQL to teach my self .

Oracle's products aren't really "free" but if you use them only
for development and testing you can just download them.

Post by e***@gmail.com
Is there any minimum of windows or Solaris requirements ?

Yes. It's all written in the installation guide.

Lots of Greetings!
Volker