Database access examples

Perl scripts - stand-alone and CGI

Each link below gives a Perl script illustrating some kind of database access. Comments are included to explain each. To be used, each script needs to be configured with a database name, and most need a username and password - see the comments. Each tries to access information in a table called Panto using an SQL SELECT query; you can test this by creating your own table called Panto in the appropriate database, or you could customize the scripts to connect to the Oracle database ora1a11, with your personal username and password for that database and customize the SELECT to query the table rb1.Panto (that's letter r, letter b, digit one) which already exists with public access permission. Note

Java applications

Rainbow rule
Dr Simon B Jones (