Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can we overcome the limiation of no.of columns with JSON document

3009602Feb 25 2020 — edited Feb 26 2020

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")

pastedImage_0.png

CONSTRAINT "PRCA_DIM_KROGER_1_pr_custatt_dim_key_pkey" PRIMARY KEY ("pr_custatt_dim_key")

Comments

Post Details

Added on Feb 25 2020
4 comments
108 views