Oracle and SQL

[DonIsHere]

Is Oracle similar to SQL?

I have a lot of experience in SQL but have absolutely no clue in Oracle.

What are the differences, if any?

thanks,
don

 

[Superwormy]

SQL isn't a database... Oracle is?

You communicate with a database using industry standard SQL. Someone please correct me if I'm wrong...

 

[WobbleWobble]

When you refer to SQL, do you mean Microsoft SQL Server or SQL the syntax language?

 

[Nothinman]

When you refer to SQL, do you mean Microsoft SQL Server or SQL the syntax language?

Yay for MS ambiguously reusing acronyms.

 

[kt]

I thought Microsoft bought off SQL server and just tagged their name onto it. Now it's called Microsoft SQL server.

 

[Nothinman]

It used to be Sybase IIRC, but SQL Server 2000 was basically a complete rewrite so no more licensed code is involved.

 

[wjsulliv]

SQL = Structured Query Language

MS SQL Server = Database tool (like Oracle, or Access) on which SQL can be used to create, alter, update, and view data.


Simple answer. Oracle is a database. You can build it using SQL statements.


The current standard for SQL is SQL2, however everybody with implementations of Databases (Oracle, MS, etc) has a few syntactical querks... If you know SQL you can do a lot in Oracle with a little research into Oracle specific syntax.

Procedures, triggers, etc are another story.

 

[manly]

Originally (many years ago), they ported over Sybase SQL Server from UNIX. So don't blame MS per se, but newbies who can't tell Oracle from "SQL".

Sybase SQL Server is now Adaptive Server Enterprise (ASE).

 

[joinT]

Originally posted by: Nothinman

When you refer to SQL, do you mean Microsoft SQL Server or SQL the syntax language?

Yay for MS ambiguously reusing acronyms.

ROFL.. It's funny cuz it's true 😱 lol