Genezzo::Havok::SQLScalar Genezzo::Havok::SQLScalar is a Perl module with scalar SQL functions.
Download

Genezzo::Havok::SQLScalar Ranking & Summary

Genezzo::Havok::SQLScalar Tags

SQL Perl module Scalar SQL functions scalar SQL

Genezzo::Havok::SQLScalar Description

Genezzo::Havok::SQLScalar is a Perl module with scalar SQL functions. Genezzo::Havok::SQLScalar is a Perl module with scalar SQL functions.SYNOPSISHavokUse("Genezzo::Havok::SQLScalar")FUNCTIONSperl functionsSee perlfunc(1) for descriptions.chomp chop chr crypt index lc lcfirst length ord pack reverse rindex sprintf substr uc ucfirst abs atan2 cos exp hex int oct rand sin sqrt srand perl_joinThe perl string join, renamed to avoid conflict with the SQL relational joinSQL string functionsconcat(char1, char2)Concatenate stringsgreatest(item1, item2...)Find the greatest element in a listinitcap(char)Return the string with the initial letter of each word capitalized, where words are defined as contiguous groups of alphanumeric chars separated by non-word chars.least(item1, item2...)Find the smallest element in a listlower(char)Return the string with all letters lowercaselpad(char1, n )Returns the string char1 padded out on the left to length n with copies of char2. If char2 is not specified blanks are used. If char1 is larger than length n it is truncated to fit.ltrim(char )Returns the string which is trimmed on the left up to the first character which is not in the specified set. If set is unspecified, blanks are trimmed.soundexKnuth's soundex from Text::Soundex.replace(char, search_str )Returns char with all occurrences of the search_str replaced by replace_str. If the replace_str is unspecified or null, it removes all occurrences of the search_str.rpad(char1, n )Returns the string char1 padded out on the right to length n with copies of char2. If char2 is not specified blanks are used. If char1 is larger than length n it is truncated to fit.rtrim(char )Returns the string which is trimmed on the rightt up to the first character which is not in the specified set. If set is unspecified, blanks are trimmed.translate(char, search_str, replace_str)Similar to perl transliteration tr/ (see perlop(1) ), returns a string where all occurrences of a character in the search string are replaced with the corresponding character in the replace string.upper(char)Returns the string with all characters uppercase.SQL math functionscosh(n)Hyperbolic cosineceil(n)Returns the smallest integer greater than or equal to nfloorReturns the largest integers less than or equal to nlnNatural log.log10Log base 10.logN(base_N, num)Returns the Log base base_N on num.mod(m,n)Returns the remainder of m divided by n.power(m,n)Returns m**nround(num )Return num rounded to m places to the right of the decimal point. M=0 if not specified. If m is negative num is rounded to the left of the decimal point.sign(n)Similar to "spaceship", returns -1 for N < 0, 0 for N==0, and 1 for N > 0.sinhHyperbolic sine.tantangenttanhHyperbolic tangent.trunc(num )Return num truncated to m places to the right of the decimal point. M=0 if not specified. If m is negative num is truncated to the left of the decimal point.SQL conversion functionsThese functions return a value of a different type than their operands.ascii(char)Return the ascii value of the first char of the string.instr(char, substring ])Returns the index (1 based, not zero based) of the substring in the char, starting at position. If occurrence and position are not specified they default to one: instr returns the index of the first occurrence of the substring. If occurrence is specified instr returns the index of the Nth occurrence. If position is negative instr begins the search from the tail end of char.nvl(char1, char2)Returns char2 if char1 is NULL, else returns char1Genezzo functionsquurl"Quote URL" - Replace all non-alphanumeric chars in a string with '%hex' values, similar to the standard URL-style quoting.quurl2"Quote URL" - Replace most non-alphanumeric chars in a string with '%hex' values, leaving spaces and most punctuation (with the exception of '%') untouched.unquurlConvert a "quoted url" string back. Requirements: · Perl

Genezzo::Havok::SQLScalar Related Software