Reputation: 1
How can I make the following query work in odi 12c?
I need your support on which components I need to use and how.
SELECT *
FROM (
SELECT *
FROM table name
ORDER BY DBMS_RANDOM.RANDOM)
WHERE rownum <= n;
I used sort component but it gives me the warning in this image.
Upvotes: 0
Views: 83