1 Reply Latest reply on Jul 12, 2016 2:41 PM by Mike Kutz

    Database API's?

    brionne

      Hi all,

      im asking around to find out the types of api's developers may have used to build on SQL.

       

      If you've used, or are currently using any, I'd be interested to know the name of the api, how useful it was and what are were its good and bad points?

       

      Any info would be greatly appreciated,

       

      cheers

      B

        • 1. Re: Database API's?
          Mike Kutz

          You may be using terminologies incorrectly. (I believe your question needs to be reworded.)

          SQL is how you do CRUD activities with the database.

          PL/SQL is the Procedural Language on top of SQL.

          SQL*Developer is an application you use to write SQL and PL/SQL code (among other things)

           

          SQL does not have APIs.

          (There is the Oracle Data Cartridge Interface [ODCI], but that is more of an API used to enhance the database's capabilities.)

           

          One method of understanding the RDBMS is to think of your Packages as APIs.  These are written in PL/SQL (for Oracle)

          That means, as a developer, you are responsible for developing the API yourself.

           

          Oracle comes with a lot of Packages (APIs) ranging from Advance Queuing to Parallel Execution and beyond.

          Each one has its purpose.

          https://docs.oracle.com/database/121/ARPLS/toc.htm

           

          My $0.02

           

          MK