VARCHAR vs NUMBER
From: Murray Shane <smurray_at_booz.bah.com>
Date: 1995/10/25
Message-ID: <46lgi8$dpp_at_booz.bah.com>#1/1
Date: 1995/10/25
Message-ID: <46lgi8$dpp_at_booz.bah.com>#1/1
Q: Is there an advantage in storing a "number" as a NUMBER data
type given that I don't need to
do any mathematical operations on this number field?
The scenario I have is this: I want to store a case tracking number
that is currently a NUMBER
data type. What if this were a VARCHAR(x) data type? I could then
use letters and numbers.
Is there a performance issue on sorting, finding, etc.?
-- --Shane Murray (offsite)Received on Wed Oct 25 1995 - 00:00:00 CET
*** Make sure to reply to ***
*** smurray_at_booz.bah.com ***