DBI: The Neophyte’s Guide

Preparing the Statement ( cont. )


#!/usr/bin/perl -w

### Load the DBI module

use DBI;

### The database handle

$dbh = DBI->connect( "dbi:Oracle:DEV", "username", "password" );

### Prepare the statement handle

$sth = $dbh->prepare( "SELECT id, name FROM megaliths" );

...

exit;

DBI: The Neophyte's Guide