CHAPTER 7Advanced Queries

In this chapter, you will see how to

Image Use the set operators, which allow you to combine rows returned by two or more queries.

Image Use the TRANSLATE() function to translate characters in one string to characters in another string.

Image Use the DECODE() function to search for a certain value in a set of values.

Image Use the CASE expression ...

Get Oracle Database 11g SQL 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.