How to print the SQL query along with the output in Python CX_ORACLE module

nmortha-Oracle

Hi,

I was trying CX_ORACLE module in PYTHON and my first python script with 'select name from v$database' query was successful.

However, i want both the query as well as the output to be displayed instead of only the query output.

how to achieve this?

thanks

Naveen

User_CC65I

Hello Naveen,

I can think of 2 easy options here.

1. You can use a print('your query here') in the python script itself.
2. As you're fetching the data from your query / sql snippet inside some variable in you python script, you can use a dbms_output.put_line('you query here') in the query / .sql file and that should do the trick. Then you can structure that string output using the python.

Regards,

Pratyush

https://www.linkedin.com/in/pratyush-basu-26b70b52/

Christopher Jones-Oracle

Using "print" will be easiest for simple testing. If you want a long-term solution, looking at extending the base connection class, see the cx_Oracle doc "Tracing SQL and PL/SQL Statements" https://cx-oracle.readthedocs.io/en/latest/user_guide/tracing_sql.html