it's easier for me..But only at first glance. Why would you want to use forms if not for its power to do all the database work on its own? Wrting everything on your own is like driving a car without using the engine ;)
What is the difference between when-validate-item and post-text-item ?WHEN-VALIDATE-ITEM is a validation-trigger. Its fired whenever an items value has changed, regeardless if you leave the item or try to save. When you do a RAISE FORM_TRIGGER_FAILURE in it, the causing action will not succeed (neither a navigation nor a COMMIT).
Can you explain what the role of ltrim?http://lmgtfy.com/?q=oracle+ltrim