Jan-02-2024, 03:23 PM
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