SQL functions programmer's reference / Arie Jones ... [et al.].

Format:

Book

Contributor:

Jones, Arie.

Language:

English

Subjects (All):

SQL (Computer program language).

Physical Description:

1 online resource (795 p.)

Edition:

1st ed.

Place of Publication:

Indianapolis, IN : Wiley Pub., c2005.

Language Note:

English

Summary:

Gives programmers two-in-one coverage, with both a ""how-to"" on SQL functions and a complete SQL functions referenceSQL is the standard language for database queries; this book's advanced coverage helps programmers write their own SQL functionsCovers both the internationally standardized SQL 99 functions and the hundreds of additional functions introduced by vendors, including the subtle variations required to successfully migrate or interoperate between vendor productsCovers the latest versions of the major relational database management system (RDMS) applications: Micros

Contents:

SQL Functions Programmer's Reference SQL Functions Programmer's Reference SQL Functions Programmer's Reference; Chapter 1: Exploring Popular SQL Implementations; Introduction to SQL; Understanding the SQL Standard; Overview of Vendor Implementations of SQL; Connecting to SQL Databases; ANSI SQL Data Types; Creating SQL Databases; Querying SQL Databases; Manipulating Data in SQL Databases; Summary; Chapter 2: Functions: Concept and Architecture; What Is a Function?; ANSI SQL Functions; Built-in Functions; Creating, Compiling, and Executing a SQL Function

Passing Parameters by Value or by ReferenceScope of a Function; Classifying SQL Functions: Deterministic and Non-Deterministic Functions; Summary; Chapter 3: Comparison of Built-in SQL Functions by Vendor; Types of Functions; Classifying Built-in SQL Functions; Overview of Built-in Functions by Vendor; Summary; Chapter 4: SQL Procedural Extensions and User-Defined Functions; Procedural versus Declarative Languages; ANSI SQL Guidance for Procedural Extensions to SQL; SQL Procedural Extensions by Vendor; Summary; Chapter 5: Common ANSI SQL Functions; ANSI Query Syntax; Aggregate Functions

String FunctionsMathematical Functions; Miscellaneous Functions; Summary; Chapter 6: Oracle SQL Functions; Oracle Query Syntax; Aggregate Functions; Analytic Functions; Character Functions; Regular Expressions; Conversion Functions; Date and Time Functions; Numeric Functions; Object Reference Functions; Miscellaneous Single-Row Functions; Summary; Chapter 7: IBM DB2 Universal Database ( UDB) SQL Functions; DB2 UDB Query Syntax; String Functions; Date and Time Functions; Conversion Functions; Security Functions; IBM DB2 UDB Special Registers; Miscellaneous Functions; Summary

Chapter 8: Microsoft SQL Server FunctionsSQL Server Query Syntax; String Functions; Date and Time Functions; Metadata Functions; Configuration Functions; Security Functions; System Functions; System Statistical Functions; Undocumented Functions; Summary; Chapter 9: Sybase ASE SQL Built-In Functions; Sybase Query Syntax; String Functions; Date and Time Functions; Conversion Functions; Security Functions; Aggregate Functions; Mathematical Functions; Text and Image Functions; System Functions; Unary System Functions; Summary; Chapter 10: MySQL Functions; MySQL Query Syntax; Aggregate Functions

Numeric FunctionsString Functions; Date-Time Functions; Miscellaneous Functions; Summary; Chapter 11: PostgreSQL Functions; PostgreSQL Query Syntax; Aggregate Functions; String Functions; Mathematical Functions; Date-Time Functions; Geometric Functions; Miscellaneous Functions; Summary; Chapter 12: ANSI SQL User-Defined Functions; User-Defined Functions or SQL Routines?; Creating UDFs; Altering UDFs; Removing UDFs; Summary; Chapter 13: Creating User-Defined Functions in Oracle; PL/SQL Compiler; Oracle 10g Compiler Optimization; Acquiring Permissions; Creating UDFs; Altering UDFs

Dropping UDFs

Notes:

"Programmer to programmer"--Cover.

Includes index.

ISBN:

9786610255849

9781280255847

1280255846

9780764598074

0764598074

OCLC:

559964803