4.01    Describe Various Types of Functions Available in SQL
4.02    Use Character, Number, and Date Functions in SELECT Statements
  Image     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 ...

Get OCA Oracle Database 11g SQL Fundamentals I Exam Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.