Question

6
Replies
1169
Views
kahym Member since 2014 5 posts
PEGA
Posted: 4 years ago
Last activity: 2 years 11 months ago
Closed
Solved

Custom SQL

Hi,

I need to randomly select a sample from Customer table. To do this, I want to run a CUSTOM sql in a report definition.

What is the best practice and steps to create an SQL that can be used inside a Report Definition?

SELECT MUSTERI_NO FROM
( SELECT MUSTERI_NO FROM V_MUSTERI_BILGI
ORDER BY dbms_random.value )
WHERE rownum < (select count(MUSTERI_NO)/10 FROM V_MUSTERI_BILGI)

***Updated by moderator: Lochan to add Categories***

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Data Integration Reporting
Moderation Team has archived post
Share this page LinkedIn