파이썬 오라클 연결 코드 Python oracle example

파이썬 오라클 연결 코드 입니다

 

 

import cx_Oracle

# Connect to the database
connection = cx_Oracle.connect("username", "password", "host:port/sid")

# Create a cursor
cursor = connection.cursor()

# Execute a query
cursor.execute("SELECT * FROM employees")

# Fetch all the rows
rows = cursor.fetchall()

# Loop through the rows
for row in rows:
    print(row)

# Close the cursor and connection
cursor.close()
connection.close()