title: Advanced SQL Functions in Oracle 10g (Wordware Applications Library)
author: Dr. Richard Earp
description: Associate Professor of Computer Science, University of West Florida
zlib_text: 
  
  
  
  
  
  
  
  
  [
  
  
  Introduction to Oracle SQL
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Basic Elements of Oracle SQL
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Data Types
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Data Type Comparison Rules
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Literals
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Nulls
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Comments
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Database Objects
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Pseudocolumns
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Operators
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Expressions
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Conditions
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Functions
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Common SQL DDL Clauses
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  SQL Queries and Subqueries
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Joins
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Types of SQL Statements
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Data Definition Language (DDL) Statements
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  TABLE
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  VIEW
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  MATERIALIZED VIEW
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  DIMENSION
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  INDEX
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  SYNONYM
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  SEQUENCE
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  FUNCTION
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  PROCEDURE
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  PACKAGE
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  TYPE
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  CONTEXT
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  LIBRARY
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  TRIGGER
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  EDITION
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  JAVA
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  GRANT
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  REVOKE
  
  
  
  
  