title: python cx_oracle cursor.rowcount returning 0 but cursor.fetchall returns data
body: <p>I have this code where I am executing a <code>select sql</code> statement from <code>python</code> code using <code>cx_oracle</code> package:</p>
  
  <pre><code>import cx_Oracle
  
  try:
      cur = conn.cursor()
      result = cur.execute('select * from table1')
      print(str(cur.rowcount))
      print(cur.fetchall())
  
  except Exception as e:
      print(e)
  </code></pre>
  
  <p>When I execute the above code I see <code>0</code> coming in for <code>cur.rowcount</code> but I see following data getting printed for <code>cur.fetchall()</code>:</p>
  
  <pre><code>[('185',), ('1860',), ('1908',)]
  </code></pre>
  
  <p><a href="http://cx-oracle.readthedocs.io/en/latest/cursor.html#Cursor.rowcount" rel="noreferrer">cx_Oracle package documentation</a> does mention <code>Cursor.rowcount</code> as a valid operation so I am not sure why in my code it is returning <code>0</code> even though the data is coming?</p>