SQL Functions in Oracle Database 10g
This course is included in our On-demand training solution.
To describe how to use SQL functions for data retrieval
Database administrators, application developers, and database operators
Familiarity with RDBMS technologies and programming techniques
SQL Functions in Oracle Database 10g use case and character-manipulation functions in SQL statements. use number and date functions in SQL statements. use number, character, and date functions to manipulate data values. identify the purpose of SQL datatype conversion functions in Oracle 10g. use the TO_CHAR conversion function with dates and numbers. use the TO_NUMBER and TO_DATE conversion functions. use conversion functions to convert values in SQL statements. use general functions in SQL statements. use conditional expressions in SQL statements. use general and conditional functions in SQL statements.