From the course: Learning Oracle Database 19c
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Use the WHERE clause - Oracle Database Tutorial
From the course: Learning Oracle Database 19c
Use the WHERE clause
- [Instructor] Let's get started with the select clause of the select statement and go over the basics of the where clause and what you can do there. The Oracle syntax for the where clause is really straightforward. It's the where keyword plus a condition. What's in that condition? The Oracle documentation tells you a lot more. There's quite a bit more, actually. You can compare columns to each other, see if columns are null, use between to see if a value is between two other values, and do pattern matching. Remember, when the conditions in the where clause are true for any given row, that row will be returned when running the select statement. In another lesson, I list the arithmetic operations you can use in a select statement. Here's a brief recap. In the where clause, you will be able to use these here, too. Before talking more about the where clause, let's show you a simple example in SQL Developer. Let's say I want to find out the employee information for Douglas Grant in the…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.