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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.