SQL 查詢有 "_" 的資料

SQL 查詢有 "_" 的資料

select * from CUSTBILLTYPE
where (FORM_CODE like '#_%' ESCAPE '#')
order by CUSTOM_NO

Oracle 隨機產生值

Oracle 隨機產生值

select
  dbms_random.normal as AAAA,
  'R'||LPAD(Trunc(dbms_random.value(0, 10000)), 4, '0') as BBBB,
  trunc(dbms_random.value(0, 1000)) as CCCC,
  dbms_random.value(1, 2) as DDDD
from dual