Re: SQL vs. Oracle

On Sun, 20 Jan 3900 12:08:56, "Owen Southwood" <owen_at_listers.co.uk> wrote:

> If anyone has experience of both, can they tell me what are the basic
> diffrences between SQL and Oracle databases? Are there any
> performance advantages to either? Is one easier to code for than the
> other? Is the syntax very different? etc.

I take it that you are referring to SQL Server from Micro"stuff", correct? I have passed the first OCP exam and did some sql server interface programming in VC++. The differences are minor but real. Some handy commands to quickly get table descriptions are not in sql server, sql server 6.5's sql (SQL is Structured Query Language which is a standard language used by most relational databases as opposed to sql server M"stuffs" attempt at a real RDBMS) I do know is missing some components (for example you can not modify a column in SQL Server 6.5 but it has been taken care of in version 7.0). SQL Server has a lot of guis and it seemed to me that in order to do some things that I could quickly do with a simple command I had to go through about a dozen clicks to do via the gui.

As far as the guts of each and comparisons of performance, I can not honestly tell you, I'm sure you realize by now that I am a anti-Microstuff bigot, though the criticisms leveled above still hold.

Anyway,....there it is!

From: Mark A. Framness
http://netnet.net/~farmer/
mframness_at_lakefield.net

Go Pack Go!
Oh balsam tree oh balsam tree I see you when I deer hunt! Brian Framness Received on Thu Jan 20 2000 - 23:15:49 CST