Skip to main content

Integration

Application Integration​

Java (JDBC):

java

Copy

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection(
    "jdbc:oracle:thin:@//hostname:1521/service_name",
    "username",
    "password"
);

Python (cx_Oracle):

python

Copy

import cx_Oracle
connection = cx_Oracle.connect(
    "username",
    "password",
    "hostname:1521/service_name"
)

Tool Integration​

SQL*Plus:

bash
Copy



# Connect to database
sqlplus username/password@ORCL
# Execute script
sqlplus username/password@ORCL @script.sql