CODEWITHSUNDEEP
sqlsqlplus
James Mclaren
James Mclaren

Reputation: 674

sqlplus - executing single statement

Currently I am executing Linux commands in Perl using the system command.

I have the working line 'sqlplus username/password@url @test.sql'

Is there any possible way to execute a single SQL statement instead of the SQL statements inside the test.sql file?

e.g.

'sqlplus username/password@url select * from TableA'

Upvotes: 0

Views: 260

Answers (1)

TenG
TenG

Reputation: 4004

The best way is to use Perl DBI and DBD for Oracle. This allows you to declare SQL statements and process the results as rowsets, instead of the rather primitive (and somewhat slower) method of processing output from sqlplus.

Link to DBD Link to DBI Quick primer Example

Upvotes: 0

Related Questions