change from mysql to oracle

[Matthew Harrison]

I currently use DBD::MySQL in my script like so:

<snip>

$dbh=DBI->connect("DBI:mysql:database=mydatabase;host=127.0.0.1;port=3306",myuser,mypass);
die "Could not connect to database" if !$dbh;
$sth = $dbh->prepare("SELECT username FROM users WHERE email= '$email'");
if ($sth && $sth->execute()){
  @results = $sth->fetchrow_array();
}

</snip>

If i wanted to start using Oracle 8i, what would I have to change? I have 
just install DBD::Oracle.

-- 
Matthew Harrison
Internet/Network Services Administrator
Genstate
www.genestate.com