Oracle? ????? ??? ?????? ?? ??? ???????. API(?? ????? ?????)? ???? Oracle ??????? ?? ?? ???? ???? ? ??? ?? ??? ?????. ? ????? Oracle API ?? ???? ??? ???? ????? ?? ???? ?? ??? ????? ??? ???? ??? ???? ???? ?? ??? ?????.

1. Oracle API ??

Oracle? ?? ??? ???? ???? ??? ? ?? ??? API? ?????.

• JDBC API: Java ????? ???? Oracle ??????? ???? ???? ? ?????.
• PL/SQL API: ?????? ??? ?? Oracle? ?? ???? ? ??? ???? ????? ?????.
• REST API: RESTful ???? ???? HTTP ????? ?? ?????? ??? ?????.
• OCI(Oracle Call Interface): C/C++ ???? ?? ???? ?? API???.

2. Oracle API ?? ???

2.1 JDBC API

JDBC API? Java ??????? Oracle ??????? ???? ?? ????? ? ?????. ??? JDBC API? ???? Oracle ??????? ???? ?? ??? ???? ??? ???? ??? ?? ?????.

import java.sql.*;

public class OracleJDBCExample {
    public static void main(String[] args) {
        String url = "jdbc:oracle:thin:@localhost:1521:ORCL";
        String user = "username";
        String password = "password";
        
        try {
            Connection conn = DriverManager.getConnection(url, user, password);
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM employees");
            
            while (rs.next()) {
                System.out.println(rs.getString("employee_name"));
            }
            
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

2.2 PL/SQL API

?????? ??? ?? Oracle? ?? ???? ? ??? ???? ? ??? ?? , PL/SQL API? ???? ??? ????? ??? ??? ? ????. ??? ?? ????? ???? ??? ???? ??? PL/SQL API ?????.

CREATE OR REPLACE PROCEDURE get_employee_details (employee_id IN NUMBER)
IS
    employee_name employees.employee_name%TYPE;
BEGIN
    SELECT employee_name INTO employee_name
    FROM employees
    WHERE employee_id = employee_id;
    
    DBMS_OUTPUT.PUT_LINE('Employee Name: ' || employee_name);
END;

2.3 REST API

Oracle? ?????? ??? ???? ?? REST API? ?????. HTTP ??? ?? RESTful ??? API? ???? CRUD ??? ??? ? ????. ??? REST API? ???? ?? ??? ???? ??? ???? ??? REST API ?????.

GET /api/employees

Response:
{
    "employees": [
        {
            "id": 1,
            "name": "Alice",
            "department": "IT"
        },
        {
            "id": 2,
            "name": "Bob",
            "department": "HR"
        }
    ]
}

2.4 OCI API

OCI? Oracle Call Interface? ??? C/C++ ???? ?? API?? ???? ?????. Oracle ??????? ?? ?? ??? ??? ??. ??? Oracle ??????? ???? ?? ??? ???? ??? ???? ??? OCI API ????.

#include <stdio.h>
#include <oci.h>

int main() {
    OCIEnv *env;
    OCIError *err;
    OCIServer *srv;
    OCISvcCtx *svc;
    OCIStmt *stmt;
    
    // Initialize OCI environment and connect to database
    
    // Prepare and execute SQL statement
    
    // Process query results
    
    // Clean up resources
    
    return 0;
}

??

? ????? Oracle API ?? ???? ??? ???? ??? ??? API? ???? Oracle ??????? ?? ???? ??? ?????. ??? ??. Java ???, PL/SQL ???, REST API ??? ?? C/C++ ????? Oracle API? ???? ? ??? ??? ?? ?? ??? ???? ??? ??? ?? ??? ? ????. ? ??? ?? ???? ????? ??? ?? Oracle? API ??? ? ??? ???? ???? ? ??? ??? ????.

? ??? Oracle API ?? ???: ??? ????? ?? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!