Home » Developer & Programmer » Forms » Format for alphanumeric characters only (Oracle Forms 9)
Format for alphanumeric characters only [message #336635] Mon, 28 July 2008 08:32 Go to next message
kaydee08
Messages: 4
Registered: February 2007
Junior Member
Can anyone assist me with creating a format mask or some method to allow only alpha-numeric characters no (#,@,*) etc. to be entered into a field in Oracle Forms.
Re: Format for alphanumeric characters only [message #336685 is a reply to message #336635] Mon, 28 July 2008 12:29 Go to previous messageGo to next message
kaydee08
Messages: 4
Registered: February 2007
Junior Member
Found something similar to this in one of forum posts, I placed this in WHEN-VALIDATE-TRIGGER of field after applying an
UPPER to vFieldVal. Returning a NULL value would indicate that only letters and\or numbers were found in field. Not sure if there is an alpha-numeric format that can be applied

SELECT LTRIM(RTRIM(vFieldVal, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'),'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789')
INTO vDummy
FROM DUAL;
Re: Format for alphanumeric characters only [message #339554 is a reply to message #336685] Thu, 07 August 2008 18:06 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Also search this forum for 'iznumeric'.

David
Previous Topic: How to display from FND_LOBS
Next Topic: Item Validation
Goto Forum:
  


Current Time: Sun Dec 11 06:33:48 CST 2016

Total time taken to generate the page: 0.25083 seconds