#!/bin/bash

parameter=$1
sqlplus= # Path to SQLPlus
username= # DB username
password= # DB password
db= # DB name

SQL="
  UPDATE some_table
    SET some_column = some_value
    WHERE some_other_column = '$parameter';"

"$sqlplus" "$username/$password @$db" << HERE

$SQL
commit;
quit
HERE