O'Reilly logo

Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) by Gavin Powell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required