I am trying to execute an SQL query from shell script.
A part of script is something like this:
fromDate=`echo $(date +"%F%T") | sed "s/-//g" | sed "s/://g"`
$ORACLE_HOME/sqlplus -s /nolog <<EOD1
connect $COSDBUID/$COSDBPWD@$COSDBSID
spool $SCMSORDERREPORT_HOME/SCMS_Order_Report.csv;
Select column1 From Table1 Where creationDate > ('$fromDate', 'YYYYMMDDHH24MISS')
spool off;
exit
EOD1
Here, I have initialized a variable fromDate in the beginning of the script, and I am trying to pass it to the SQL query. Is this the right way or I need to change the way how it is passed to query? I am not getting anything in the spooled file and I suspect there is something wrong with the way the parameter has been passed.
Please help!