http://www.perlmonks.org?node_id=954428


in reply to Re^2: How to use oracle SHOW commands with DBI
in thread How to use oracle SHOW commands with DBI

Looks like you're right. I don't have an Oracle DB to test, but I just played around with it on a MySQL DB, and invoking 'SHOW' this way works fine:

perl -MData::Dumper -MDBI -we'$x=DBI->connect("dbi:mysql:wp", "yeah", +"fer_sure"); print Dumper($x->selectall_arrayref("SHOW VARIABLES"))'
-- 
I hate storms, but calms undermine my spirits.
 -- Bernard Moitessier, "The Long Way"