CHAPTER 7Advanced Queries
In this chapter, you will
Learn how to use the set operators, which allow you to combine rows returned by two or more queries.
Use the TRANSLATE() function to convert characters in one string to characters in another string based on a set of translation characters.
Use the DECODE() function to search a set of values for a certain value.
Learn how to use the CASE expression to perform if-then-else logic in SQL without ...
Get Oracle Database 10g 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.
