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.
Describe various types of functions available in SQL
Use character, number, and date functions in
SELECT
statementsUsing Conversion Functions and Conditional Expressions
Describe various types of conversion functions that are available in SQL
Use the
TO_CHAR()
,TO_NUMBER()
, andTO_DATE()
conversion functions
You may think that there couldn't possibly be any more functions to see, but there are. In...