my dog learned polymorphism*
The moose likes Oracle/OAS and the fly likes types oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "types oracle" Watch "types oracle" New topic

types oracle

Maiquel knechtel

Joined: Jan 31, 2009
Posts: 6
What types should I use the Oracle database?

price | numeric or float ?

customer_id | numeric ?

Maiquel Knechtel

SCJP 5.0
SCWCD{in progress}

Alan Kay: "The best way to predict the future is to invent it."
mukesh nair

Joined: Nov 23, 2008
Posts: 7
for price you can use float
and for customer_id you can go varchar as if it contain alphanumeric values
subject: types oracle
Similar Threads
Oracle jdbc driver getColumnType return Number
~ and !
Need to parse StringBuffer
casting String to ?
DB error in servlet while inserting data