Do you understand the usage difference between single quotation and double quotation marks in SQL?
Printable View
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));
:) :) :)