OCA Oracle Database 11g SQL Fundamentals I Exam Guide

CERTIFICATION OBJECTIVES

4.01    Describe Various Types of Functions Available in SQL

4.02    Use Character, Number, and Date Functions in SELECT Statements

       Two-Minute Drill

Q&A   Self Test

 

Functions are a wonderful extension to SQL and provide a first glimpse of the procedural capabilities Oracle supports. Procedural languages allow a rich degree of programming that yields an almost unlimited range of data manipulation possibilities. Oracle server implements a proprietary procedural language called PL/SQL, or procedural SQL. A range of ...