My DB is ORACLE.
I plan to create a procedure through LIQUIBASE.
But, When I write some SQL like below
…
…
if(X >= Y) then
Z := 1;
end if;
…
…
I run it through CMD.
CMD show me some errors because of sign “>” is invaild.
My DB is ORACLE.
I plan to create a procedure through LIQUIBASE.
But, When I write some SQL like below
…
…
if(X >= Y) then
Z := 1;
end if;
…
…
I run it through CMD.
CMD show me some errors because of sign “>” is invaild.
This is XML and “>” has to be escaped using “>”
…
if(X >= Y) then…
You can also use a CDATA block too, depending on what works better for you.
Nathan