SQL functions programmer's reference /

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 internationall...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Otros Autores: Jones, Arie
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, IN : Wiley Pub., Ã2005.
Temas:
SQL (Computer program language)
SQL (Langage de programmation)
COMPUTERS > Programming Languages > CÄ
COMPUTERS > Programming Languages > Java.
COMPUTERS > Programming Languages > Pascal.
Acceso en línea:Texto completo
Tabla de Contenidos:
  • 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

Ejemplares similares