create table more than 1000 colum
802304May 19 2011 — edited May 20 2011Hello
I have 1500+ column in my select query. how to create table like my query is
create table xyz nologging as
select a1,a2,a3,a4,a5,b1,b2,b3,b4,b5,................a1500
from abcd a,bcde b
where a.a1=b.b1
In oracle 10g I can create only 1000 column in a table.
Please suggest