DB2 user needs help using Oracle SQL*Plus

beeblequix · 06-11-2012, 12:00 PM

I've depended on DB2's ability to run outside of interactive mode in my bash scripts. I like how I can throw DB2 commands at the database and on the next line run awk/sed/grep/etc. Now I've got to do the same thing but on an Oracle database using SQL Plus.

What's the SQL Plus version of these DB2 non-interactive commands?

1. db2 connect to SOMEDATABASE user SOMEUSER using SOMEPASSWORD

2. db2 -x "select count(*) from SOME_TABLE where TRANSACTION_TIME between '2012-06-11 10:30:00.000' and '2012-06-11 10:30:10.999'"

Thanks.

john2 · 06-18-2012, 11:11 AM

It's been a while since I used Oracle, but as there are zero replies so far here goes...

As far as I remember the syntax for the first one is
CONN username/password@identifier
http://docs.oracle.com/cd/B19306_01/...57/ch12015.htm

The second one needs the TO_DATE function - examples here:
http://psoug.org/definition/TO_DATE.htm

If you want to send the output to a file you need the SPOOL command
http://www.exampledepot.com/egs/java...bleToFile.html

To run sqlplus from bash scripts:
http://www.dbsnaps.com/oracle/oracle...-bash-scripts/

Hope this is of help.