rrrygghydf
Reputation: 1
Different results in cx_Oracle compared with SQL Developer
I work with Oracle database and cx_oracle. The problem I have is that when I have a query, it returns the wrong answer in cx_oracle. But this query is the correct answer in SQL developer. What is my problem? This is my query:
select id from my_table
in sql developer we have the right result, but Returns deleted records in cx_oracle.It looks like the records is cached and returned.
Upvotes: 0
Views: 195
Answers (1)
Related Questions
- cx Oracle not showing query results
- Python and CX_Oracle Invalid SQL Statement
- cx_Oracle Query Performance
- Python cx_Oracle merge mystery - working in SQL Dev not working in python33
- cx_Oracle and SQL Developer don't agree on CURRENT_DATE
- cx_oracle missing right parenthesis
- cx_Oracle query returns zero rows
- cx_Oracle returns empty query when using bindings
- SQL statement executes in sql developer but fetches entire table in python (cx_Oracle)
- why cx_Oracle and sqlplus give different results for the same select query