IT Professionals

[PARAMASHIVAN]

Help needed App na / Kirukan pls

I have a table called Customer, with fields called customer_id, cust_name and nick name, I want a trigger that would update nick_name,
when ever a value is inserted into cust_name .

the sql command starts some thing like this

create trigger test
on customer
for update as

I amnot sure of the code after this ...