-2

I can not understand that matter: How can I display "01738163258" (a phone number including '0' in the first index without char,varchar type) in Oracle Database 11g

Cœur
  • 37,241
  • 25
  • 195
  • 267
Subrata K Paul
  • 76
  • 1
  • 4
  • 2
    Possible duplicate of [How to display the leading zero's in a number of oracle](http://stackoverflow.com/questions/25968792/how-to-display-the-leading-zeros-in-a-number-of-oracle) – Lukasz Szozda Dec 06 '15 at 18:14
  • You are confusing data storage with data display or formatting - these are two separate concerns. – Jeffrey Kemp Dec 09 '15 at 08:02

1 Answers1

1

A "telephone number" is not a number unless you're going to add them together, take the average, or the maximum, etc.

Store them as varchars with a check constraint to ensure that they meet a particular pattern -- for example that they are composed only of digits, spaces, maybe a leading "+".

David Aldridge
  • 51,479
  • 8
  • 68
  • 96