plsql developer in python

[dawid294]

I have the problem with my script. The script works good, but not for big script. I would like to use big SQL script with left join , inner join and etc. but after this script does not work. Why Can you help me, What I have to change in script or What script can i use? Thank you so much

import cx_Oracle

connection=cx_Oracle.connect("dw1","dw2","//local1/DW3")
cursor=connection.cursor()
rs = cursor.execute("select*from tab t where t.date)>'1.12.2023'")

for row in rs:
    print(row)
    
%load_ext sql
%sql oracle+cx_oracle://dw1:dw2@local/?service_name=DW3
        
%sql select*from tab t where t.number=1