oracle 랜덤 날짜 구하기
UPDATE 테이블
SET 칼럼 =
ROUND(dbms_random.value(2001,2014)) ||
TO_CHAR( ROUND(dbms_random.value(1,12)) , 'FM09') ||
TO_CHAR( ROUND(dbms_random.value(1,28)) , 'FM09')
'DB > oracle' 카테고리의 다른 글
| oracle / db link (0) | 2020.04.24 |
|---|---|
| CentOS6.5 / Oracle11g / The listener supports no services (0) | 2020.04.24 |
| oracle / job / batch (0) | 2020.04.17 |
| oracle / dbms_scheduler (0) | 2020.04.17 |
| oracle / expdp / impdp (0) | 2020.04.17 |