how can i get rows from cx_oracle without for loop

Question

As said in cx_oracle documentation, for getting rows of a query i should write a for loop. e.g.:

with connection.cursor() as cursor:
    for row in cursor.execute("select * from MyTable"):
        print(row)

how can I take these rows without for loop? btw, I may use JSON_OBJECT to directly get JSON from oracle. thanks for your attention:)

According to PEP-249 the convenient way is to use fetch[one|many|all] method of the cursor object rather than looping over cursor.execute as long as the result of this call is not defined (i.e. implementation-dependent) — astentx
– astentx, Commented Apr 20, 2022 at 10:56
Are you trying to fetch the rows as a JSON object? Something else? Please clarify! — Anthony Tuininga
– Anthony Tuininga, Commented Apr 20, 2022 at 20:56

Barbaros Özhan · Accepted Answer · 2022-04-20 11:24:37Z

1

You can alternatively use while loop, after fetching all dataset and returning them as may times as the length of the array such as

row = cursor.execute('SELECT * FROM MyTable').fetchall()

i=0
while i < len(row):
    print(row[i])
    i+=1

answered Apr 20, 2022 at 11:24

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Christopher Jones · Accepted Answer · 2022-04-20 21:41:34Z

1

The cx_Oracle documentation has some alternatives:

cur = connection.cursor()
cur.execute("select * from MyTable")
while True:
    row = cur.fetchone()
    if row is None:
        break
    print(row)

or

cur = connection.cursor()
cur.execute("select * from MyTable")
num_rows = 10
while True:
    rows = cur.fetchmany(num_rows)
    if not rows:
        break
    for row in rows:
        print(row)

or

cur = connection.cursor()
cur.execute("select * from MyTable")
rows = cur.fetchall()
for row in rows:
    print(row)

answered Apr 20, 2022 at 21:41

Christopher Jones

11.1k7 gold badges32 silver badges64 bronze badges

Collectives™ on Stack Overflow

how can i get rows from cx_oracle without for loop

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related