SQL::Statement::Functions SQL::Statement::Functions are built-in & user-defined SQL functions.
Download

SQL::Statement::Functions Ranking & Summary

SQL::Statement::Functions Tags

SQL Perl module built-in built-in SQL functions user-defined SQL functions user-defined

SQL::Statement::Functions Description

SQL::Statement::Functions are built-in & user-defined SQL functions. SQL::Statement::Functions are built-in & user-defined SQL functions.SYNOPSIS SELECT Func(args); SELECT * FROM Func(args); SELECT * FROM x WHERE Funcs(args); SELECT * FROM x WHERE y < Funcs(args);This module contains the built-in functions for SQL::Parser and SQL::Statement. All of the functions are also available in any DBDs that subclass those modules (e.g. DBD::CSV, DBD::DBM, DBD::File, DBD::AnyData, DBD::Excel, etc.).This documentation covers built-in functions and also explains how to create your own functions to supplement the built-in ones. It's easy! If you create one that is generally useful, see below for how to submit it to become a built-in function.Function syntaxWhen using SQL::Statement/SQL::Parser directly to parse SQL, functions (either built-in or user-defined) may occur anywhere in a SQL statement that values, column names, table names, or predicates may occur. When using the modules through a DBD or in any other context in which the SQL is both parsed and executed, functions can occur in the same places except that they can not occur in the column selection clause of a SELECT statement that contains a FROM clause. # valid for both parsing and executing SELECT MyFunc(args); SELECT * FROM MyFunc(args); SELECT * FROM x WHERE MyFuncs(args); SELECT * FROM x WHERE y < MyFuncs(args); # valid only for parsing (won't work from a DBD) SELECT MyFunc(args) FROM x WHERE y; Requirements: · Perl

SQL::Statement::Functions Related Software