PERL one liner

Shell Programming and Scripting
1

hi,

I am using PERL one liner for oracle database connection as :

$PERL -e "use DBI; DBI->connect(qw(DBI:Oracle:SID user passwd));"

is there a way to append select statement to this connection ? i.e. DB connection and select stmt in one line ?

how to do sysdba connection using one lines ?
inside the program I am uisng like this :

$db = DBI->connect("DBI:Oracle:", undef, undef, { ora_session_mode => &ORA_SYSDBA });

but, it's failing through one liner .....

Thanks in adv .

2

FYI: your one liner is actually 3 lines of perl code separated by ";".