Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Oracle Community (OTN)
Customer Advisory Board Archived Forums
This discussion is archived
on Mar 29, 2012 7:13 PM by Sandeep Gandhi, Consultant
Formatting a Number
Mar 29, 2012 6:17 PM
Actually this is the representation of product no in the database.But when i give 1234567890 also(without -) ,it should give the details of that product.
How can i implement this in the code.
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: Formatting a Number
Sandeep Gandhi, Consultant
Mar 29, 2012 7:13 PM
in response to
Your question is not clear. Do you simply want to suppress the dashes in the product number?
select replace(column_name,'-',null) from your_table;