O'Reilly logo

Oracle Database 10g SQL by Jason Price

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 7Advanced Queries

In this chapter, you will

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

Image Use the TRANSLATE() function to convert characters in one string to characters in another string based on a set of translation characters.

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

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