How many columns can table have in Oracle?

Question

Do i need to write in PL/SQL or is it possible in SQL query?

Answer 1

one table can have maximum 1000 columns.

Comments

Yes you are right, for 8i, 9i, 10g, and 11g, the limit is 1,000 columns per table. Prior to that, Oracle 7 had a 254 column limit.

Answer 2

The number of columns in a table can range from 1 to 254.

Answer 3

SQL Server Maximum Columns Limit

Bytes per short string column 8,000

Bytes per GROUP BY, ORDER BY 8,060

Bytes per row 8,060

Columns per index key 16

Columns per foreign key 16

Columns per primary key 16

Columns per nonwide table 1,024

Columns per wide table 30,000

Columns per SELECT statement 4,096

Columns per INSERT statement 4096

Columns per UPDATE statement (Wide Tables) 4096

When you combine varchar, nvarchar, varbinary, sql_variant, or CLR user-defined type columns that exceed 8,060 bytes per row