Hi,
I'm using a query like this.
select ":new.name" ":=" nvl(":new.name",fun11(test)) from dual;
when I execute it I'm getting the error as from keyword not found where expected .
where is the problem.
can anyone help me ?
thanks,
kkr12.
Printable View
Hi,
I'm using a query like this.
select ":new.name" ":=" nvl(":new.name",fun11(test)) from dual;
when I execute it I'm getting the error as from keyword not found where expected .
where is the problem.
can anyone help me ?
thanks,
kkr12.
What are you trying to get out of this statement? Are you trying to build a string containing some dynamically created trigger text?
if not, how about:
x:= nvl(:new.name,fun11(test));