I need a UNIX shell script to convert my queries from Java compatible to Oracle compatible format. ie.
I have all the java compatible queries:
java:
SELECT a, b, c, d, e, f,g "+// "from test where year(timestamp)=year(today) and month(timestamp)=month(today) "
+// "and day(timestamp)=2 and h='" + "W" + "'"
Oracle
SELECT a, b, c,d,e,f,g from test where
year(timestamp)=year(today) and
month(timestamp)=month(today) and
day(timestamp)=2 and h='W'
Is it possible using sed or awk?