Hi,
We have a requirement to create table in Oracle database with unlimited no. of columns. Since there is a limitation on no. of columns, I am thinking that whether we can overcome that issue by using JSON document got introduced in 12c. We have a table called PRCA_DIM_KROGER_I and we need to create more than 1000 columns for that.
Please let us know if that is possible, if so are there any issues in terms of performance while accessing or ingesting the data.
your inputs are very much appreciated.
Regards
~Uppal.
CONSTRAINT "PRCA_DIM_KROGER_1_pr_custatt_dim_key_pkey" PRIMARY KEY ("pr_custatt_dim_key")

CONSTRAINT "PRCA_DIM_KROGER_1_pr_custatt_dim_key_pkey" PRIMARY KEY ("pr_custatt_dim_key")