Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number Fields Size???

Status
Not open for further replies.
CptTom

CptTom

Programmer
Jul 16, 2001
117
0
0
US
I am not an Oracle Programmer, but I have to pull flat-text data from Oracle tables. Having said that, I am trying to figure out the formula to determine how much space to allocate to numeric fields. All of our tables are Number (x,x) and it appears that the vast majority are 10 spaces. The ones that are (2,0), (3,0) and (5,0) are all 10 spaces, but the (6,3) is 14. If I am to write a script to automatically read these flat text files, I need to know how to calculate size, and my "Complete Reference Guide" isn't.

Larry
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Format a number - TO_CHAR() 2
Replies
5
Views
191
SkipVought
S
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
111
Livia8
Livia8
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
202
carp
carp
LarrySteele
  • Locked
  • Question
Searching multiple fields for any/all words from a search string.
Replies
2
Views
54
LarrySteele
LarrySteele
DTGMI
  • Locked
  • Question
Solaris 10 and Bad Magic Number in Disk label
Replies
0
Views
65
DTGMI
DTGMI

Part and Inventory Search

Sponsor

Back
Top