O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

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

Summary

In this chapter, we've examined some of the many single-row functions available to you as a SQL coder. We've looked at the structure and purpose of functions, as well as the different types that exist. We have used string functions in data transformation, worked with numeric functions to accomplish arithmetic operations, and used datatype conversion functions to convert values between datatypes. We closed with a look at functions that conditionally retrieve data in a way similar to the if...then statements found in other third-generation programming languages.

Certification objectives covered

  • Describe various types of functions available in SQL
  • Use character, number, and date functions in SELECT statements
  • Using Conversion Functions and Conditional ...

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