Chapter 4. Operators, Conditions, Pseudocolumns, and Expressions
Terms You Need to Understand
✓ Operator
✓ Condition
✓ Pseudocolumn
✓ Expression
✓ ROWID
✓ ROWNUM
Concepts You Need to Master
✓ Expressions are combinations of other expressions, operators, conditions, and pseudocolumns
✓ The rules of precedence
✓ The concatenation operator (||)
✓ Different expression types
✓ Composition of a ROWID
This chapter introduces details for all Oracle SQL operators, conditions, pseudocolumns, and expressions. Operators allow the composition of multiple expressions. Conditions allow comparison between expressions. Pseudocolumns contain information in Oracle databases not available from tables and can be embedded in expressions. Expressions are combinations of other expressions, ...
Get Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) 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.
