title: How to generate a range of random number with fixed value in sql
body: <p>I am running the following code. For every execution I am getting the result of my query. But for every execution It's giving me different random value of SUPPLIER_ID. I want the value of SUPPLIER_ID to be fixed every time. Please help me with this.</p>
  
  <pre><code>SELECT
      T.*,
      C.*,
      LC.SUPPLIER_NAME,
      L.LOCAL_COMMODITY_DESC,
      CASE WHEN C.INVOICE_DESCRIPTION IS NULL
      THEN 'NO'
      ELSE 'YES' END AS DEPEND_OTHER
  FROM OYSTER_WEB3.TRANSACTION T,
  Local_Feed_Commodity_Map L,
  OYSTER3.CAT_RULE_MV C,
  OYSTER3.LOCAL_COMMON_SUPPLIER_MAP LC
      WHERE
      C.CAT_RULE_ID=T.CAT_RULE_ID
      AND
      C.DATA_FEED_CODE=LC.DATA_FEED_CODE
      AND
      T.SUPPLIER_CODE=C.LOCAL_SUPPLIER_CODE
      AND
      C.LOCAL_SUPPLIER_CODE=LC.SUPPLIER_CODE
      AND
      T.DATA_FEED_CODE=L.DATA_FEED_CODE
      AND
      C.LOCAL_COMMODITY_CODE=L.LOCAL_COMMODITY_CODE
      AND
      L.Local_Commodity_Code =         (SUBSTR(T.LOCAL_COMMODITY_CODE,1,INSTR(T.LOCAL_COMMODITY_CODE,'~')-1))
      AND T.TRANSACTION_DATE&gt;='01-JAN-09'
      AND LC.SUPPLIER_ID IN
      (select trunc(dbms_random.VALUE(21852,2268730)) num from dual CONNECT BY LEVEL&lt;=200);
  </code></pre>