Skip to content

Instantly share code, notes, and snippets.

@iriiiina
Created August 7, 2017 17:56
#!/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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment