From the course: Oracle Database 19c: Basic SQL
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Expressions in SELECT and WHERE clauses
From the course: Oracle Database 19c: Basic SQL
Expressions in SELECT and WHERE clauses
- The term expressions is a mathematical construct that extends into Oracle Database 19 C. I'll show you how to construct an expression in Oracle and leverage them in both the Select clause and the Where clause. Here are the definitions of an expression. The first is a purely mathematical definition. The second is the definition from the Oracle Database PL/SQL programming perspective. They are very close if not identical. A mathematical result from combining numbers, variables, and higher level functions with operands that you'd see in mathematics, such as addition, subtraction, multiplication, and division. Here are some examples of expressions. They can be as simple as multiplying two values together. A number transformed with a mathematical function or a single value as you can see in the first three examples. The last four are still expressions with an Oracle twist. You can use built in functions, but the variables in the definition in our table columns like salary, or database…
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.