you don't pay for the api, whoever is running the hardware where the oracle database is, pays for the database
you using the api, will put load on the database, which will consume CPU, and those CPUs have to be licensed, or you pay by named user (you), or you pay by monthly CPU usage (cloud subscription)
Where is this 'api' you are looking at, or this a theoretical API that you will be building?
Thank you for your reply.
I spoke theoretically, I assumed that Oracle developed an API for their Database, so if a client has, for example, an app, he can easily configuring access to the database.
I saw this "API"
Is that right, or Oracle doesn't provide any API I can work with?
I just want to provide an API key to my app (for access) and with this key, the app will be able to show the specific table that related to a specific client.
you can use that technology (ords) to build the api for your database to give to your app
you can use the 'automatic api' feature for tables, and use it to pull up, change, delete, or add records to that table if you have the key (oauth2)
I have never built an API
Are you familiar with any premade API that I can implement and adjust to my needs?
Where will be the best place to read about implementing API/build? (a guide will be great)