OraFAQ Forum: Forms » Insert DATA in my DB on uppercase format

Home » Developer & Programmer » Forms » Insert DATA in my DB on uppercase format (oracle forms 10g ,win xp pack 2)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Insert DATA in my DB on uppercase format [message #580059]

Tue, 19 March 2013 14:53

goldray
Messages: 97
Registered: December 2012

Member

Hi,
I have a datablock based , I used commit_form(); to insert data in my DB .
But,I want to insert data into my DB on uppercase format!!

Any suggestions ?

Report message to a moderator

Re: Insert DATA in my DB on uppercase format [message #580060 is a reply to message #580059]

Tue, 19 March 2013 14:56

Littlefoot
Messages: 16928
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

One option is to create a BEFORE INSERT (and possibly UPDATE) database trigger which will force conversion to uppercase letters using the UPPER function.

Report message to a moderator