For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
like this ?
select case when dbms_random.value(0,1) < 0.5 then 'y' else 'n' end is_successful from dual
or this ?
select translate(dbms_random.string('U',1),'ABCDEFGHIJKLMNOPQRSTUVWXYZ','ynynynynynynynynynynynynyn') from dual
Regards
Etbin
Message was edited by: Etbin user596003
Message was edited by: user596003
select chr(121 - 11 * (round(dbms_random.value))) is_successful from dual
select distinct First_Value(is_successful) over(order by dbms_random.value) as is_successful from (select 'n' as is_successful from dual union all select 'y' from dual);
similar thread 569577
substr('yn', dbms_random.value(1,3), 1)