iframe-proxy | Sunbelt Computer Software

46 lines (38 loc) · 1.19 KB

#------------------------------------------------------------------------------
# Copyright (c) 2016, 2020, Oracle and/or its affiliates. All rights reserved.
#------------------------------------------------------------------------------
#------------------------------------------------------------------------------
# Demonstrate how to perform a query in different ways.
#------------------------------------------------------------------------------
import cx_Oracle
import SampleEnv
connection = cx_Oracle.connect(SampleEnv.GetMainConnectString())
        select * from SampleQueryTab
        where id < 6
        order by id"""
print("Get all rows via iterator")
cursor = connection.cursor()
for result in cursor.execute(sql):
    print(result)
print("Query one row at a time")
cursor.execute(sql)
row = cursor.fetchone()
row = cursor.fetchone()
print("Fetch many rows")
cursor.execute(sql)
res = cursor.fetchmany(numRows=3)
print("Fetch each row as a Dictionary")
cursor.execute(sql)
columns = [col[0] for col in cursor.description]
cursor.rowfactory = lambda *args: dict(zip(columns, args))
for row in cursor:
    print(row)

Sunbelt Computer Software

PL/B Language Development and Support

Navigation Menu

Sunbelt Computer Software

PL/B Language Development and Support

FilesExpand file tree

Query.py

Latest commit

History

Query.py

File metadata and controls