| Number of rows fetched [message #144656] |
Thu, 27 October 2005 10:07  |
GePs
Messages: 2
Registered: October 2005
Location: Torino, Italy
|
Junior Member |
|
|
In OCI (the language is C), how can I know the number of rows fetched by a sql select? I can read the number of columns after executing a query with the OCIAttrGet() on a statement handle with the prameter OCI_ATTR_PARAM_COUNT set, but trying with the same function whit OCI_ATTR_ROW_COUNT I obtain nothing!!!!
please help me! GePs
|
|
|
|
| Re: Number of rows fetched [message #150015 is a reply to message #144656] |
Tue, 06 December 2005 00:38  |
kmohan
Messages: 28
Registered: July 2005
|
Junior Member |
|
|
|
there are two ways: fetch all rows and keep a counter, or select count(*). If you are not selecting count(*), you will not know how many rows match your query criteria, till you actually fetch the rows.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
