iframe-proxy | Sunbelt Computer Software

39 lines (31 loc) · 1012 Bytes

#------------------------------------------------------------------------------
# Copyright (c) 2016, 2019, 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)

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