I have a shell script trying to execute a simple SQL statement and storing it in a single variable is. But I am unable to do this. I am using Sigwin and I intend to use it in Unix. See script below
"execute a script" echo Id = (sqlplus cimnewuser / cimnewuser @ cimnew identification id from the list where tablename = 'mCT_35618'; exit) "$ var" code> This is giving me the error I want to manipulate SQL in SQL New am
Thank you in advance!
You are not forgeting $ .
var = $ (sqlplus cimnewuser / cimnewuser @ from the cimnew list in the list, where tablename = optionally, you can use brackets: < Code> var = 'sqlplus ... `
No comments:
Post a Comment