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!

Database columns name for JSON-key name/property name

RaffyMartinAug 25 2016 — edited Aug 25 2016

Hello everyone,

I have been reading about API design and I have played with ORDS and since the JS naming convention is camelCase it is recommended to stick to standard used in JS and JSON, but we have snake-case tables and column names in the database.

How can I convert/map/ the columns or add an alias (just like in the object name) to a camelCase using ORDS?

What other things to consider when trying to do this or are there other side effects this will have when receiving back the JSON resources in the database (as we will be receiving camelCase but our tables are snake-case)?

I would assume this should have been built-in, but I cannot find anything in the documentation. I would guess it would be some sort of model where this could be assigned.

Thank you in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2016
Added on Aug 25 2016
0 comments
526 views