Sql Stored Procedure Tutorial

Template::Tutorial::Datafile is a Perl module for creating Data Output Files Using the Template Toolkit. This tutorial gives an overview of the Template Toolkit, showing in particular how to use it to read and write data files in various different formats and styles. It was written by Dave...

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

yagg::Tutorial is a Perl module that contains a tutorial for yagg. SYNOPSIS # To use the generator ./yagg -m nonterminals.yg terminals.lg ./output/progs/generate 5 This tutorial will show you how to use yagg, by way of two examples. In the first example, we create a simple logical...


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

Catalyst::Manual::Tutorial::AdvancedCRUD is a Catalyst Tutorial - Part 8: Advanced CRUD. Add a Form Creation Helper Method Open lib/MyApp/Controller/Books.pm in your editor and add the following method: =head2 make_book_widget Build an HTML::Widget form for book creation and updates...


Platforms: *nix

XML::Smart::Tutorial is a Perl module with tutorials and examples for XML::Smart. SYNOPSIS This document is a tutorial for XML::Smart and shows some examples of usual things..


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

DateTime::Format::Builder::Tutorial is a quick class on using Builder. CREATING A CLASS As most people who are writing modules know, you start a package with a package declaration and some indication of module version: package DateTime::Format::ICal; our $VERSION = 0.04; After that, you...


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

Jifty::Manual::Tutorial is a Perl module for Zero to Jifty in a Jiffy. This tutorial should give you everything you need to build your first application with Jifty. HOW TO The requirements Heres what you need to have installed -- at least when we write it. Installing Jifty No bones...


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

Rose::DB::Object::Tutorial is a guided tour of the basics of Rose::DB::Object. INTRODUCTION This document provides a step-by-step introduction to the Rose::DB::Object module distribution. It demonstrates all of the important features using a semi-realistic example database. This tutorial does...


Platforms: *nix

Task::Catalyst::Tutorial is a Perl module that installs everything you need to learn Catalyst. SYNOPSIS Installs the example "MyApp" described in Catalyst::Manual::Tutorial, and all its dependencies..


Platforms: *nix

PDF::Reuse::Tutorial is a Perl module that will teach you how to produce PDF-files with PDF::Reuse. In this tutorial I will show some aspects of PDF::Reuse, so you should be able to use it in your own programs. Most important is how to produce and reuse PDF-code, and then if you are interested,...


Platforms: *nix