A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Multiple fields of Long type
Joined: Oct 26, 2002
Jun 10, 2006 23:22:00
Why Oracle complains when trying to add more than one fields of LONG type? It says - "a table may contain only one column of type LONG".
Joined: Apr 14, 2004
Jun 12, 2006 06:20:00
Because that is how it is designed.
The LONG datatype is deprecated anyway. Assuming you are not using an unsupported version of Oracle (i.e. v8i or below) you would use a LOB datatype instead. You can have more than one LOB field in a table.
It is sorta covered in the
JavaRanch Style Guide
subject: Multiple fields of Long type
select vs count(*) - Performance Comparison
B&S Update Method Data too long
Hibernate @GeneratedValue problem
Long and Int
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014