2 Replies Latest reply: Sep 21, 2013 12:32 PM by 979801 RSS

    Text Item Format Masking in Oracle forms

    979801

      Hello Experts,               I am using oracle 11g forms with windows 7.I have to make a text field for an account number(having a length of 10 digits).In this when I type the input number(suppose it is of 8 digit length) then there is a prefix(two zeros according to fulfill the maximum length to account text field) added to input.I have made this using a logic in pl/sql but i want to know that there is any built-in function or any pl/sql function available in oracle for this functionality. thnk you.