What is the column limit in Oracle 10G and Derby Databases

Question

Until recently, I thought that the limit on the number of columns in Oracle DB was 255. But the limit is 1000. Can someone confirm this?

I also tried to find if there is any similar limit on the number of columns in Derby DB, especially the built-in java DB derby

Answer 1

Here's a link to the Oracle documentation: Logical Database Constraints .
Excerpts:

Per table 1000 columns maximum Per index (or clustered index) 32 columns maximum Per bitmapped index 30 columns maximum 

---

Here's a link to the Derby documentation: Derby database
Excerpts:

 columns per table 1,012