From the course: Oracle Database 12c: Advanced SQL

Unlock the full course today

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

Creating complex views

Creating complex views - Oracle Database Tutorial

From the course: Oracle Database 12c: Advanced SQL

Start my 1-month free trial

Creating complex views

“

- [Instructor] Because Oracle's data disputes can essentially be used where regular database tables are used as part of the sequel queries, you can also join database views and database tables in the same sequence statement. That's because database views can essentially be used interchangeably where tables are used. Going to exercise file, let's copy the select statement, and paste it to our sequel developer window. This is a fairly straight forward sequel statement which joins the emp sales view with the departments view as if emp sales was a table and not a view. Running the sequel command, we see that we got our results back as expected. In addition to using views as part of a joint syntax in our sequel queries, you can also create the view that contains the joint syntax as part of the view syntax itself. So, for example, going to our exercise file, let's copy the create view locations view syntax and paste it into our sequel developer window. Here we are creating a locations view…

Contents