Skip to Main Content
Forums

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

trigger for Lpadding

548780May 22 2008 — edited May 22 2008
Hi,

while executing query to populate data into a number field in forms it should lpad with '0's if its length is less than 8, in which trigger it can done.

SELECT LPAD(:VALUE_TO,8,0) INTO :VALUE FROM DUAL;

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 19 2008
Added on May 22 2008
#forms, #moved-from-devops
4 comments
577 views