Return multiple rows in python function

Question

Am trying to print multiple rows with the return statement, but it is printing only one record.

def extract(self):
    data = self.oracle_conn().execute('select * from employees').fetchall()
    for row in data:
        
        return row

Any suggestion will be helpful to print multiple lines without using pandas

Use the print(row) to print rows.. your code will return the first row because return exits the function, returning the value to the caller. — vaizki
– vaizki, Commented Sep 13, 2022 at 13:50
I actually need to pass the return value to another function, that's the reason i need it as return value — Jim Macaulay
– Jim Macaulay, Commented Sep 13, 2022 at 13:52
If the suggestion from Luis is not sufficient, use an example to demonstrate what you are trying to do! — Anthony Tuininga
– Anthony Tuininga, Commented Sep 13, 2022 at 14:19

Nishant · Accepted Answer · 2022-09-13 14:09:50Z

1

def extract(self):
    data = self.oracle_conn().execute('select * from employees').fetchall()
    for row in data:
        yield row

Nishant

22.2k20 gold badges79 silver badges110 bronze badges

answered Sep 13, 2022 at 14:06

RobertG

4163 silver badges8 bronze badges

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

1 Answer 1