取随机的商品代码 5 个

（1）

SELECT SHOHINCD
  FROM MMSYHINMASTER SAMPLE BLOCK(5)
 WHERE COMPANYID = 'F1'
   AND DELETECLASS = '0'
   AND ROWNUM <= 5;

 

（2）

SELECT SHOHINCD
  from (select *
          from MMSYHINMASTER
         WHERE COMPANYID = 'F1'
           AND DELETECLASS = '0'
         order by dbms_random.value)
 where rownum <= 5;