Powered by Ajaxy
Digg StumbleUpon LinkedIn YouTube Flickr Facebook Twitter RSS Reset

Perl: How to Connect to Oracle

Perl: How to Connect to Oracle
{filelink=14655}

#!/perl/bin
use DBI;
use strict;
# Create a connection to Oracle Database
my $db_connect = DBI->connect('dbi:Oracle:Test','scott','tiger');
my $Query="SELECT Name, LastName FROM users";
my $statement = $db_connect->prepare($Query);
$statement->execute
	|| die "Unable to execute this query";
# Returns an array that corresponds to the fetched row
while (my @row=$statement->fetchrow_array)
{
   print "@row n";
}
$db_connect->disconnect();

Users who found this page were searching for:

  • perl dbi oracle +bigdecimal
  • python to read a binary file
  • how to reset read position python
  • perl script access to oracle database
  • java InternetAddress multi receivers
  • iterate over dictionary python

No comments yet.

Leave a Comment