We help IT Professionals succeed at work.

set item in form

191 Views
Last Modified: 2018-02-02
how can i set value to this after insert
6210-14-242-8258
 
set item emp to be in this format after i insert which trigger must i use
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
Isn't this the same as your previous question:
https://www.experts-exchange.com/questions/29008102/inserting-value-in-table-in-oracle-form.html

I remember other questions that were very similar about screen masking versus inserting the data.

Author

Commented:
no is not the same i just what to display value in this form in oracle form 6210-14-242-8258
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
If you want to physically update the data to add the dashes in the table on insert, then the form should just be able to display what it receives without any format masking.

If this is what you want to do, you should be able to apply the formatting inside the form and insert the data in the desired format.  I remember you asked a question on how to do that.  I just cannot find it.

I've not used forms for many years but are you wanting forms triggers or database level triggers?

If database level triggers:
If you cannot get forms to insert the data correctly, as a last resort you should be able to create a before insert trigger.  You might need an after insert trigger if forms interferes with the before trigger.
awking00Information Technology Specialist
CERTIFIED EXPERT

Commented:
Can you show some sample values that get inserted and how you would like them to be after an update?

Author

Commented:
FM0999-99-999-9999
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
select regexp_replace(mycol,'([0-9]{4})([0-9]{2})([0-9]{3})([0-9]{4})','\1-\2-\3-\4')