need help in shell shell scripting with oracle

Published: 4/05/2018
need help in shell shell scripting with oracle
Source: UNIX.STACKEXCHANGE.COM

I am trying to substitute a unix variable to a select statement, but I am getting the below error. What did I do wrong? sqlplus "/ as sysdba" << EOF spool /home/oracle/l.log archive log list; exit; EOF Adest=`cat /home/oracle/l.log |head -4|tail -1|awk '{print $3}` sqlplus "/ as sysdba" << EOF spool /home/oracle/register.lst select 'alter database register logfile '||''''||$

Read more
Related news
Comment
FACEBOOK