Hi ,

Can we customize report definition any way to form the below query , Sort or Group By forms ORDER BY ASC/DESC , How can we add ORDER BY DBMS_RANDOM.VALUE

SELECT * FROM schema.tablename ORDER BY DBMS_RANDOM.VALUE

basically I am trying to aviod using connet-sql rule and see if any option using Report Definition