1

The question sounds a bit weird, but basically, SQL is different from MySQL and I think Microsoft SQL too (not too sure). What about Oracle? The wiki page for SQL didn't mention if Oracle is a variant, and I can't find anything on Oracle's website. The answer may be there, but the site is hard to navigate.

My boss asked me to read up on SQL. The project is using Oracle database. Does studying vanilla SQL count or is Oracle's database language different?

Improve this question
7
  • SQL dialect like in real world + PL/SQL procedural part which is Oracle specific. So first learn Oracle SQL(but be aware that it may introduce things that are not in standard SQL) then procedural language. Commented Jan 18, 2016 at 10:30
  • ANSI/ISO SQL is the standard, some products' SQL are closer to the standard, and some are not very close at all... Commented Jan 18, 2016 at 10:33
  • 2
    There is no 100% ANSI SQL database server (except experimental). Every real DB has its dialect: PL/SQL, T-SQL, etc. Commented Jan 18, 2016 at 10:34
  • 2
    Related: What is the difference between SQL, PL-SQL and T-SQL? Commented Jan 18, 2016 at 10:40
  • So to learn the SQL used on Oracle, what should I be looking for? Commented Jan 18, 2016 at 10:45

1 Answer 1

Reset to default
0

I'm no expert, but I learned that there is an "SQL standard", as jarlh told, ANSI/ISO SQL, and every database manager (MySQL, Oracle, SQL Server, etc) has its own syntax for different cases and internal working, near this standard, like use the commit command or not, datatypes, etc.

For example:

comparison page on SQL

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.