From the course: Oracle Database 12c: Basic SQL

Unlock the full course today

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

Oracle join syntax vs. ANSI syntax

Oracle join syntax vs. ANSI syntax - Oracle Database Tutorial

From the course: Oracle Database 12c: Basic SQL

Start my 1-month free trial

Oracle join syntax vs. ANSI syntax

“

- [Instructor] Note that in addition to writing SQL joins, using the standard SQL syntax, also known as the ANSI syntax, which we saw throughout this chapter, Oracle also has it's own proprietary syntax for performing joins on tables in the database. The Oracle syntax is equivalent to the ANSI standard SQL syntax. However, for cross database compatibility, most users choose to write SQL commands when using joins, using the standard ANSI syntax. So let's see the Oracle-specific join syntax in action. We can type: select first_name, last_name, department_name and by now you probably understand that I'm going to be joining the employees, and departments table together, as we have done throughout this chapter. And here is where the change in syntax starts to occur. So, using the Oracle join syntax, I'll type: from employees, departments. Note that I'm not specifying any join syntax between these two tables, just a comma, and I perform the actual join itself in the where clause of my…

Contents