Do you understand the usage difference between single quotation and double quotation marks in SQL?
Thanks a lot for your time and sugessions. Now I got the solution of my problem, Here is shell script part of code change Code: DATE_FORMAT="YYYYMMDD" DATE_FORMAT=`echo "'"$DATE_FORMAT"'"` EMPNAME=`echo "'"$EMPNAME"'"` EMPID=`echo "'"$EMPID"'"` DATEGEN=`echo "'"$DATEGEN"'"` Using above syntax I am able to insert records into my table as, Code: INSERT INTO TBL1(EMPNAME,EMPID,EMPBDATE) VALUES($EMPNAME,$EMPID,TO_DATE($DATEGEN,$DATEFORMAT));
Forum Rules