+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: plsql developer in python (/thread-41370.html)
plsql developer in python - dawid294 - Jan-02-2024
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