Breaking News: Grepper is joining You.com. Read the official announcement!

Oracle cx_Oracle example

Eneldo Serrata answered on June 9, 2022 Popularity 6/10 Helpfulness 3/10

answer Oracle cx_Oracle example

Oracle cx_Oracle example

Comment

# myscript.py

import cx_Oracle

# Connect as user "hr" with password "welcome" to the "orclpdb1" service running on this computer.
connection = cx_Oracle.connect(user="hr", password="welcome",
                               dsn="localhost/orclpdb1")

cursor = connection.cursor()
cursor.execute("""
        SELECT first_name, last_name
        FROM employees
        WHERE department_id = :did AND employee_id > :eid""",
        did = 50,
        eid = 190)
for fname, lname in cursor:
    print("Values:", fname, lname)

Popularity 6/10 Helpfulness 3/10 Language sql

Source: cx-oracle.readthedocs.io

Tags: oracle sql

Link to this answer
Share Copy Link