Sql Compare Decimals

DBIx::SQL::Abstract is a Perl module that provides a convenient abstraction layer to a database. SYNOPSIS use DBIx::SQL::Abstract; my $dbh = DBIx::SQL::Abstract->new( %dbcfg ); Building SQL Abstractions. my($query, @bind) = $dbh->select($table, @fields, %where, @order); my($query,...

Chemistry::SQL is an access database functions module. SYNOPSIS use strict; use Chemistry::SQL; use Chemistry::Artificial::SQL; my $db_name = $ARGV[0]; my $file = $ARGV[1]; my $db1 = Chemistry::SQL::new(db_host=>"127.0.0.1",db_user=>"root",db_port=>"3306",db_pwd=>"",...

SQL::Routine::Language is a Perl module for what language or grammar SQL::Routine speaks. SQL::Routine contains SQL schemas and queries, represented as a tree of atomic tokens; it is structurally like an abstract syntax tree or an XML DOM, but one that only accepts, respectively, a specific...


Platforms: *nix

SYNOPSIS use Array::Compare; my $comp1 = Array::Compare->new; $comp->Sep(|); $comp->Skip({3 => 1, 4 => 1}); $comp->WhiteSpace(0); $comp->Case(1); my $comp2 = Array::Compare->new(Sep => |, WhiteSpace => 0, Case => 1, Skip => {3 => 1, 4 => 1}); my @arr1 = 0 .. 10; my @arr2 = 0 .....


Platforms: *nix

SQL::Abstract::Limit is a portable LIMIT emulation. SYNOPSIS use SQL::Abstract::Limit; my $sql = SQL::Abstract::Limit->new( limit_dialect => LimitOffset );; # or autodetect from a DBI $dbh: my $sql = SQL::Abstract::Limit->new( limit_dialect => $dbh ); # or from a Class::DBI class: my...


Platforms: *nix

SQL::Interpolate is a Perl module to interpolate Perl variables into SQL statements. SYNOPSIS use SQL::Interpolate qw(:all); # Some sample data to interpolate: my $s = blue; my @v = (5, 6); # Variable references are transformed into bind parameters. # The most basic usage involves...


Platforms: *nix

SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux..


Platforms: *nix

SQL::Preproc is a Perl module to embed SQL in your Perl (ala SQL preprocessors). SYNOPSIS use SQL::Preproc subclass => Chart, emit => 1, keepsql => 1, syntax => [ Teradata ], pponly => 1, relax => 1, alias => 1, debug => 1; use DBI; use DBI qw(:sql_types); use...


Platforms: *nix

SQL Admin is a Java client application to connect and send queries to different databases through JDBC. SQLAdmin uses the brand new SWT Toolkit. The main idea is to create a multiplatform and multidatabase thin client. For example, you can connect to an Microsoft SQL Server from a Linux...


Platforms: *nix

SQL::Translator::Manual is a Perl module that contains a manual for SQL translator. SYNOPSIS SQL::Translator (AKA "SQLFairy") is a collection of modules for transforming (mainly) SQL DDL files into a variety of other formats, including other SQL dialects, documentation, images, and code. In...


Platforms: *nix

SQL::Translator::Producer::GraphViz is a GraphViz producer for SQL::Translator. SYNOPSIS use SQL::Translator; my $trans = new SQL::Translator( from => MySQL, # or your db of choice to => GraphViz, producer_args => { out_file => schema.png, add_color => 1, show_constraints => 1,...


Platforms: *nix

Oracle::SQL is a Perl extension for building SQL statements. SYNOPSIS use Oracle::SQL; No automatically exported routines. You have to specifically to import the methods into your package. use Oracle::SQL qw(:sql); use Oracle::SQL /:sql/; use Oracle::SQL :sql; This is a package...


Platforms: *nix

List::Compare is a Perl module to compare elements of two or more lists. SYNOPSIS The bare essentials: @Llist = qw(abel abel baker camera delta edward fargo golfer); @Rlist = qw(baker camera delta delta edward fargo golfer hilton); $lc = List::Compare->new(@Llist, @Rlist);...


Platforms: *nix

SQL::Statement::Embed can embed a SQL engine in a DBD or module. SQL::Statement is designed to be easy to embed in other modules and to be especially easy to embed in DBI drivers. It provides a SQL Engine and the other module needs to then provide a data source and a storage mechanism. For...


Platforms: *nix

Dimedis::Sql is a SQL/DBI Interface for banking applications. SYNOPSIS use Dimedis::Sql; my $sqlh = new Dimedis::Sql ( ... ); $sqlh->install ( ... ); my $seq_id = $sqlh->insert ( ... ); my $modified = $sqlh->update ( ... ); my $blob_sref = $sqlh->blob_read ( ... ); $sqlh->use_db (...


Platforms: *nix

SQL::Shell is a command interpreter for DBI shells. SYNOPSIS use SQL::Shell; #Initialise and configure my $sqlsh = new SQL::Shell(%settings); $sqlsh->set($setting, $new_value); $value = $sqlsh->get($setting); #Interpret commands $sqlsh->execute_command($command);...


Platforms: *nix

SQL::Generator is a Perl module to generate SQL-statements with oo-perl. SYNOPSIS use SQL::Generator; With this module you can easily (and very flexible) generate/construct sql-statements. As a rookie, you are used to write a lot of sprintf`s every time i needed a statement (i.e.for DBI)....


Platforms: *nix

DL/SQL is declarative, turing-complete programming language based on top of SQL database. The main idea is to store both program and data in one SQL table and make all the computations in it. The current version of interpreter written in PHP contains quasi-lazy evaluation and simple caching....


Platforms: *nix

SQL::Amazon::Request::Help is an Interface to retrieve Help content. SYNOPSIS $dbh = DBI->connect(dbi:Amazon:, $amznid, undef, { amzn_mode => books, amzn_locale => us, amzn_max_pages => 3 }) or die "Cannot connect: " . $DBI::errstr; # # search for some Perl DBI books # $sth =...


Platforms: *nix

SQL::Amazon::UserGuide is a Perl module with user Guide for DBD/SQL::Amazon. SYNOPSIS # # create the parser, passing in the current Amazon metadata # my $parser = SQL::Amazon::Parser->new(%attrs); # # parse a SQL statement, returning a SQL::Amazon::Statement # my $stmt =...


Platforms: *nix