I've never come across a block size of 64K before. Are you sure you don't mean the stripe size which is commonly this value?
Anyway, there is this 8K limit on the block size in oracle. Make sure your Db_file_multiblock_read_count is 8 or a multiple thereof (which it is).
This is, I believe, an age old question for all RDBMSs. And to which there is no good answer. THe two strategies that work are:
a) Generate what you want in a for loop and
b) Pre-load a table with the dates you need.
There is no other worthwhile solution.
The last reply is OK, but should read a.sal<b.sal to do what you need. Also it will possibly be inefficient on a large table. If you have any kind of procedural control you can try the simple, but obvious approach of
select ename, sal
from emp
order by sal desc;
Then fetch the first n rows...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.