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!

How to display phone number with code in text item

rootsMar 3 2011 — edited Mar 3 2011
Hello friends,

I have "customer_management" table. In this table i have one field phone number in varchar2 data type.
the storage format of phone number is :(code-phone number ) For example 0902334-324345
Ok. I created one form from this table as data block. In this form i want to display code and phone number in two text items.. So i should create a query to do this..Pls help me to make a query.. Which trigger is suitable for this ?
Pls give me sample query..

Thanks
This post has been answered by 781692 on Mar 3 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2011
Added on Mar 3 2011
#forms, #moved-from-devops
16 comments
863 views