A simple query!!!

[kkr12]

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.

[kmesser]

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));