Index
A
ADD_MONTHS function
Aggregate functions
AVG (
see
Average (AVG) function)
COUNT function
column
DISTINCT
parameters
SUM function
WHERE clause
definition
LOWER function
MAX function
records
syntax
WHERE
MIN function
records
syntax
WHERE clause
SUM (
see
SUM function)
tasks
ALTER TABLE statement
CASCADE CONSTRAINTS
column
constraint
data type
DROP TABLE
foreign key
primary key
remove column
rename column
structure of
table rename
AND keyword
Average (AVG) function
all values
COUNT function
DISTINCT
SUM and COUNT functions
WHERE clause
B
BETWEEN operator
don’t match, values
greater than or equal to and less than or equal to
inclusive and exclusive check
syntax
text values
two values
BINARY_FLOAT data type
Binary large object (BLOB)
C
CASE statement
case_name
conditions
vs. DECODE function ...
Get Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
