ns2easy
ns2easy

Reputation: 1

How to select a certain number of random values with odi 12 c?

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.

1

Upvotes: 0

Views: 83

Answers (0)

Related Questions