<button id="ufg2m"><acronym id="ufg2m"></acronym></button>
        <span id="ufg2m"></span>
      1. <button id="ufg2m"><acronym id="ufg2m"></acronym></button>
        <progress id="ufg2m"><track id="ufg2m"><video id="ufg2m"></video></track></progress>
        <rp id="ufg2m"><object id="ufg2m"><input id="ufg2m"></input></object></rp>
          <dd id="ufg2m"></dd>

          <em id="ufg2m"><object id="ufg2m"></object></em>
          主頁 > 知識庫 > 數據庫 > Oracle >

          oracle取隨機結果測試

          來源:中國IT實驗室 作者:佚名 發表于:2013-07-16 15:45  點擊:
          oracle取隨機結果測試 create table t as select * from all_objects where rownum = 5000; select object_name, object_id from ( select object_name, object_id from t where object_name like %% order by dbms_random.random ) where rownum = 4; selec
           oracle取隨機結果測試  create table t as select * from all_objects where rownum <= 5000;
            select object_name, object_id
            from ( select object_name, object_id
            from t
            where object_name like '%%'
            order by dbms_random.random )
            where rownum <= 4;
            select object_name, object_id
            from ( select object_name, object_id
            from t sample ( 1 )
            where object_name like '%%'
            order by dbms_random.random )
            where rownum <= 4;
            create table tt(ss number(10));
            declare
            v_out number(3);
            i     number(10);
            begin
            i := 1;
            while i <= 10000 loop
            begin
            insert into tt values(i);
            i := i + 1;
            end;
            end loop;
            --dbms_output.put_line(v_out);
            end;
            /
            commit;
            select dbms_random.random from dual;
            select * from (select * from tt order by dbms_random.random) where rownum<11;

            有幫助
            (0)
            0%
            沒幫助
            (0)
            0%
            yy午夜理伦4080菠萝视频无码_国产乱伦一级片_国产播放隔着超薄丝袜进入_在线观看AV无码片