RE: [PBML] Database objects.
- It looks like the DBI and DBD packages together have an Oracle interface.
$dbh = DBI->connect("dbi:Oracle:$dbname", $user, $passwd);
$dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid", $user, $passwd);
It is not part of the "standard" modules. If using ActiveState's ActivePerl,
download with PPM. Else download with CPAN.
> -----Original Message-----
> From: Zabil Cheriya Maliackal [mailto:zabilcm@...]
> Sent: Tuesday, January 30, 2001 1:15 AM
> To: email@example.com
> Subject: [PBML] Database objects.
> Could anyone tell me how to connect to a database and get all
> information about a particular table. Like I want to connect
> to the oracale
> database using PERL and then obtain all the information on
> the table DEPT
> like the constraints, the column names whether the field is
> nullable etc.