Search Results

sqlplus will run the script file using @filename not just the filename.

See:
#!/bin/sh

A=`sqlplus -s /nolog @test.sql`

echo $A

test.sql should contain something like.
connect...

Example how to insert stuff in Oracle from a simple shell-script:
#!/bin/bash
ORACLE_SID="my_sid"
# Other oracle stuff if you need them, $ORACLE_HOME, $PATH etc
MYVAR="apple"

sqlplus -s...