SQL from a perl program

I have a program which executes the
following :
system("sqlplus login/login@password")

this logs me into an SQL session.
Is there a way I can now execute
SQL statements from the perl program?
admiralAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mjswartConnect With a Mentor Commented:
That's right,
there is no way to execute sql statements from within the perl program.
However, you can store the sql program in a file and use
system("sqlplus login/password@machine < statement.sql");

good luck
0
 
olthoffCommented:
use DBI;

This allows you to connect to the database and run whatever queries that you like.
0
All Courses

From novice to tech pro — start learning today.