1.
select t.t_credit_id
from (select * from t_credit order by dbms_random.value) twhere t.login_name like '%er%'
2.select *
from t_credit t
where t.login_name like '%er%'
order by dbms_random.value
1.
select t.t_credit_id
from (select * from t_credit order by dbms_random.value) twhere t.login_name like '%er%'
2.select *
from t_credit t
where t.login_name like '%er%'
order by dbms_random.value