From the course: Learning Oracle Database 19c

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

The ANSI SQL language standard

The ANSI SQL language standard - Oracle Database Tutorial

From the course: Learning Oracle Database 19c

Start my 1-month free trial

The ANSI SQL language standard

“

- [Instructor] In a database shop, especially a heterogeneous environment with multiple vendors, you're going to hear about ANSI SQL. Let's talk about what ANSI SQL means and whether it's that important even when you have several versions of several vendor's databases running in your data center. What is ANSI? The American National Standards Institute. Their goal is to provide somewhat objective standards to ensure safety and speak a common language for everything from paper sizes, to eye protection, to hot tubs. When it comes to Oracle database, we're concerned about the SQL language. It has evolved over the years primarily from vendor enhancements and the desire for interoperability. The first SQL standard was formulated in 1986, and most recently the draft version of SQL 2019 was released. What about Oracle Database 19c SQL? You can't say whether Oracle SQL is compliant with a simple yes/no answer. Oracle Database 19c SQL is compliant for the most part with the ISO 2016 version of…

Contents