DB/sql
oracle , mssql 범위 난수 발생 구문
건빵쥔광이씨
2020. 11. 17. 23:27
-- oracle
select
chr(trunc(dbms_random.value(97, 122), 0)) ,
chr(trunc(dbms_random.value(97, 122), 0)) ,
chr(trunc(dbms_random.value(33, 90), 0)) ,
chr(trunc(dbms_random.value(33, 47), 0)) ,
chr(trunc(dbms_random.value(48, 57), 0)) ,
chr(trunc(dbms_random.value(33, 90), 0))
from ANY_TABLE
-- mssql
select
lower(char(cast(round((122-97)*rand()+97, 0) as integer))) + '' +
lower(char(cast(round((122-97)*rand()+97, 0) as integer))) + '' +
lower(char(cast(round((90-33)*rand()+33, 0) as integer))) + '' +
lower(char(cast(round((47-33)*rand()+33, 0) as integer))) + '' +
lower(char(cast(round((57-48)*rand()+48, 0) as integer))) + '' +
lower(char(cast(round((90-33)*rand()+33, 0) as integer)))