Hi can someone tell me what the following syntax means?
(current_timestamp(2), 'Start of step class1');
AND another one
(coalesce(b.step-a.step Hour(4) To second(2));
Thank you,
(current_timestamp(2), 'Start of step class1') may give you two columns one containing a current time with seconds to 2 decimals and the other the literal 'Start of step class1' in each row.
select current_timestamp(2) as ctime,
'Start of step class1' as lit
results =
ctime lit
2005-06-22 09:14:38.10+00:00 Start of step class1
(coalesce(b.step-a.step Hour(4) To second(2)) may return the hours and seconds from b in hh:mm:ss.ss format or NULL if it does not exist.
Whether the action block of an Update Trigger can have more than one statements?
Can we use conditional/selection statements in the action block of an update trigger(For each statement trigger)?
Can some please send some help and examples onto that?
AnupMaurya:
I have no exsperience with triggers. Since this question has little relation to the original question, I suggest you start a new thread, with a new subject.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.