TOracleQuery.RowsProcessed or TOracleDataSet.RecordCount
- Thread starter Devil
- Start date
That won't work, 2147483647 records is the limit. You would have to redesign the query into multiple smaller queries.
Ok. How to redesign the query?
You mean in where clause for first query
set:
where ...
rownum between 1 and 2147483647
for second query set:
where ...
rownum between 2147483647 and 4294967294 --2147483647+2147483647
of course I'm use bind variables instead of integer values
If used rownum, this is will be guaranteed what queries not return cross records?
You mean in where clause for first query
set:
where ...
rownum between 1 and 2147483647
for second query set:
where ...
rownum between 2147483647 and 4294967294 --2147483647+2147483647
of course I'm use bind variables instead of integer values
If used rownum, this is will be guaranteed what queries not return cross records?
Jens Fudickar
Member³
That will not work.
where
rownum between 2147483647 and 4294967294
will never return a value.
rownum is a pseudocolumn which always starts with 1 and counts the "RESULT".
If you say rownum > 1 then for the first record the result is false and the record is not returned and then rownum is not increased.
This is an oracle-sql restriction.
Greetings
Jens
where
rownum between 2147483647 and 4294967294
will never return a value.
rownum is a pseudocolumn which always starts with 1 and counts the "RESULT".
If you say rownum > 1 then for the first record the result is false and the record is not returned and then rownum is not increased.
This is an oracle-sql restriction.
Greetings
Jens
For example, if this is a join, change it to a master query and a subquery.
Single join with many rows:
Code:
select d.dname, e.ename
from dept d, emp e
where e.deptno = d.deptno
Code:
select deptno, dname
from dept
select ename
from emp
where depnto = :v_deptno
