반응형
/****************************** FUNCTION 생성하기 ************************************/
CREATE OR REPLACE FUNCTION GETTEMPNUM
CREATE OR REPLACE FUNCTION GETTEMPNUM
(
P_NULL NUMBER /* NULL 리턴율 */
, P_BGN NUMBER /* 범위시작숫자 */
, P_END NUMBER /* 범위종료숫자 */
, P_SCL NUMBER /* 반올림자릿수 */
, P_TYPE NUMBER /* 0:기본, 1:정규분포, 2:역정규분포, 3:롱테일, 4:롱헤드, 5:정비례, 6:역비례, 7:증가, 8:감소 */
) RETURN NUMBER
IS
/*
* PGM ID : GETTEMPNUM
* TITLE : 임시데이터생성
* AUTHOR : grapro.lim@gmail.com
* DATE : 2011.09.27
* VERSION : 1.0
* CONTENTS :
* RUNCYCLE :
* RUNTIME :
* MODIFIED :
*/
V_RTN_VAL NUMBER;
V_RND NUMBER;
V_RND2 NUMBER;
BEGIN
V_RND := DBMS_RANDOM.VALUE;
IF (1-V_RND) <= P_NULL/100 THEN
RETURN NULL;
END IF;
IF P_NULL = 0 OR P_NULL IS NULL THEN
V_RND2 := V_RND;
ELSE
V_RND2 := V_RND/(1-(P_NULL/100)); /* 1로 스케일링 */
END IF;
V_RND2 := CASE
WHEN P_TYPE = 1 THEN /* 정규분포 */
CASE WHEN V_RND2 <= 0.000201369311316955 THEN ((V_RND2-0)*(1/100)/0.000201369311316955)+0
WHEN V_RND2 <= 0.000402738622633911 THEN ((V_RND2-0.000201369311316955)*(1/100)/0.000201369311316955)+0.01
WHEN V_RND2 <= 0.000604107933950866 THEN ((V_RND2-0.000402738622633911)*(1/100)/0.000201369311316955)+0.02
WHEN V_RND2 <= 0.00100684655658478 THEN ((V_RND2-0.000604107933950866)*(1/100)/0.000402738622633911)+0.03
WHEN V_RND2 <= 0.00140958517921869 THEN ((V_RND2-0.00100684655658478)*(1/100)/0.000402738622633911)+0.04
WHEN V_RND2 <= 0.00201369311316955 THEN ((V_RND2-0.00140958517921869)*(1/100)/0.000604107933950866)+0.05
WHEN V_RND2 <= 0.00281917035843737 THEN ((V_RND2-0.00201369311316955)*(1/100)/0.000805477245267821)+0.06
WHEN V_RND2 <= 0.00382601691502215 THEN ((V_RND2-0.00281917035843737)*(1/100)/0.00100684655658478)+0.07
WHEN V_RND2 <= 0.00503423278292388 THEN ((V_RND2-0.00382601691502215)*(1/100)/0.00120821586790173)+0.08
WHEN V_RND2 <= 0.00644381796214257 THEN ((V_RND2-0.00503423278292388)*(1/100)/0.00140958517921869)+0.09
WHEN V_RND2 <= 0.00805477245267821 THEN ((V_RND2-0.00644381796214257)*(1/100)/0.00161095449053564)+0.1
WHEN V_RND2 <= 0.00986709625453081 THEN ((V_RND2-0.00805477245267821)*(1/100)/0.0018123238018526)+0.11
WHEN V_RND2 <= 0.0118807893677004 THEN ((V_RND2-0.00986709625453081)*(1/100)/0.00201369311316955)+0.12
WHEN V_RND2 <= 0.0142972211035038 THEN ((V_RND2-0.0118807893677004)*(1/100)/0.00241643173580346)+0.13
WHEN V_RND2 <= 0.0171163914619412 THEN ((V_RND2-0.0142972211035038)*(1/100)/0.00281917035843737)+0.14
WHEN V_RND2 <= 0.0203383004430125 THEN ((V_RND2-0.0171163914619412)*(1/100)/0.00322190898107128)+0.15
WHEN V_RND2 <= 0.0241643173580346 THEN ((V_RND2-0.0203383004430125)*(1/100)/0.00382601691502215)+0.16
WHEN V_RND2 <= 0.0285944422070077 THEN ((V_RND2-0.0241643173580346)*(1/100)/0.00443012484897302)+0.17
WHEN V_RND2 <= 0.0336286749899315 THEN ((V_RND2-0.0285944422070077)*(1/100)/0.00503423278292388)+0.18
WHEN V_RND2 <= 0.0392670157068063 THEN ((V_RND2-0.0336286749899315)*(1/100)/0.00563834071687475)+0.19
WHEN V_RND2 <= 0.0455094643576319 THEN ((V_RND2-0.0392670157068063)*(1/100)/0.00624244865082561)+0.2
WHEN V_RND2 <= 0.0525573902537253 THEN ((V_RND2-0.0455094643576319)*(1/100)/0.00704792589609344)+0.21
WHEN V_RND2 <= 0.0604107933950866 THEN ((V_RND2-0.0525573902537253)*(1/100)/0.00785340314136126)+0.22
WHEN V_RND2 <= 0.0690696737817157 THEN ((V_RND2-0.0604107933950866)*(1/100)/0.00865888038662908)+0.23
WHEN V_RND2 <= 0.0791381393475634 THEN ((V_RND2-0.0690696737817157)*(1/100)/0.0100684655658478)+0.24
WHEN V_RND2 <= 0.0898107128473621 THEN ((V_RND2-0.0791381393475634)*(1/100)/0.0106725734997986)+0.25
WHEN V_RND2 <= 0.101288763592429 THEN ((V_RND2-0.0898107128473621)*(1/100)/0.0114780507450665)+0.26
WHEN V_RND2 <= 0.113370922271446 THEN ((V_RND2-0.101288763592429)*(1/100)/0.0120821586790173)+0.27
WHEN V_RND2 <= 0.126459927507048 THEN ((V_RND2-0.113370922271446)*(1/100)/0.0130890052356021)+0.28
WHEN V_RND2 <= 0.140153040676601 THEN ((V_RND2-0.126459927507048)*(1/100)/0.013693113169553)+0.29
WHEN V_RND2 <= 0.154450261780105 THEN ((V_RND2-0.140153040676601)*(1/100)/0.0142972211035038)+0.3
WHEN V_RND2 <= 0.169552960128876 THEN ((V_RND2-0.154450261780105)*(1/100)/0.0151026983487716)+0.31
WHEN V_RND2 <= 0.185058397100282 THEN ((V_RND2-0.169552960128876)*(1/100)/0.0155054369714056)+0.32
WHEN V_RND2 <= 0.201167942005638 THEN ((V_RND2-0.185058397100282)*(1/100)/0.0161095449053564)+0.33
WHEN V_RND2 <= 0.217680225533629 THEN ((V_RND2-0.201167942005638)*(1/100)/0.0165122835279903)+0.34
WHEN V_RND2 <= 0.234595247684253 THEN ((V_RND2-0.217680225533629)*(1/100)/0.0169150221506242)+0.35
WHEN V_RND2 <= 0.251913008457511 THEN ((V_RND2-0.234595247684253)*(1/100)/0.0173177607732582)+0.36
WHEN V_RND2 <= 0.269633507853403 THEN ((V_RND2-0.251913008457511)*(1/100)/0.0177204993958921)+0.37
WHEN V_RND2 <= 0.287756745871929 THEN ((V_RND2-0.269633507853403)*(1/100)/0.018123238018526)+0.38
WHEN V_RND2 <= 0.306081353201772 THEN ((V_RND2-0.287756745871929)*(1/100)/0.0183246073298429)+0.39
WHEN V_RND2 <= 0.324607329842932 THEN ((V_RND2-0.306081353201772)*(1/100)/0.0185259766411599)+0.4
WHEN V_RND2 <= 0.343334675795409 THEN ((V_RND2-0.324607329842932)*(1/100)/0.0187273459524768)+0.41
WHEN V_RND2 <= 0.362263391059203 THEN ((V_RND2-0.343334675795409)*(1/100)/0.0189287152637938)+0.42
WHEN V_RND2 <= 0.381393475634313 THEN ((V_RND2-0.362263391059203)*(1/100)/0.0191300845751108)+0.43
WHEN V_RND2 <= 0.400724929520741 THEN ((V_RND2-0.381393475634313)*(1/100)/0.0193314538864277)+0.44
WHEN V_RND2 <= 0.420257752718486 THEN ((V_RND2-0.400724929520741)*(1/100)/0.0195328231977447)+0.45
WHEN V_RND2 <= 0.439991945227547 THEN ((V_RND2-0.420257752718486)*(1/100)/0.0197341925090616)+0.46
WHEN V_RND2 <= 0.459927507047926 THEN ((V_RND2-0.439991945227547)*(1/100)/0.0199355618203786)+0.47
WHEN V_RND2 <= 0.479863068868304 THEN ((V_RND2-0.459927507047926)*(1/100)/0.0199355618203786)+0.48
WHEN V_RND2 <= 0.5 THEN ((V_RND2-0.479863068868304)*(1/100)/0.0201369311316955)+0.49
WHEN V_RND2 <= 0.520136931131696 THEN ((V_RND2-0.5)*(1/100)/0.0201369311316955)+0.5
WHEN V_RND2 <= 0.540072492952074 THEN ((V_RND2-0.520136931131696)*(1/100)/0.0199355618203786)+0.51
WHEN V_RND2 <= 0.560008054772453 THEN ((V_RND2-0.540072492952074)*(1/100)/0.0199355618203786)+0.52
WHEN V_RND2 <= 0.579742247281514 THEN ((V_RND2-0.560008054772453)*(1/100)/0.0197341925090616)+0.53
WHEN V_RND2 <= 0.599275070479259 THEN ((V_RND2-0.579742247281514)*(1/100)/0.0195328231977447)+0.54
WHEN V_RND2 <= 0.618606524365687 THEN ((V_RND2-0.599275070479259)*(1/100)/0.0193314538864277)+0.55
WHEN V_RND2 <= 0.637736608940797 THEN ((V_RND2-0.618606524365687)*(1/100)/0.0191300845751108)+0.56
WHEN V_RND2 <= 0.656665324204591 THEN ((V_RND2-0.637736608940797)*(1/100)/0.0189287152637938)+0.57
WHEN V_RND2 <= 0.675392670157068 THEN ((V_RND2-0.656665324204591)*(1/100)/0.0187273459524768)+0.58
WHEN V_RND2 <= 0.693918646798228 THEN ((V_RND2-0.675392670157068)*(1/100)/0.0185259766411599)+0.59
WHEN V_RND2 <= 0.712243254128071 THEN ((V_RND2-0.693918646798228)*(1/100)/0.0183246073298429)+0.6
WHEN V_RND2 <= 0.730366492146597 THEN ((V_RND2-0.712243254128071)*(1/100)/0.018123238018526)+0.61
WHEN V_RND2 <= 0.748086991542489 THEN ((V_RND2-0.730366492146597)*(1/100)/0.0177204993958921)+0.62
WHEN V_RND2 <= 0.765404752315747 THEN ((V_RND2-0.748086991542489)*(1/100)/0.0173177607732582)+0.63
WHEN V_RND2 <= 0.782319774466371 THEN ((V_RND2-0.765404752315747)*(1/100)/0.0169150221506242)+0.64
WHEN V_RND2 <= 0.798832057994362 THEN ((V_RND2-0.782319774466371)*(1/100)/0.0165122835279903)+0.65
WHEN V_RND2 <= 0.814941602899718 THEN ((V_RND2-0.798832057994362)*(1/100)/0.0161095449053564)+0.66
WHEN V_RND2 <= 0.830447039871124 THEN ((V_RND2-0.814941602899718)*(1/100)/0.0155054369714056)+0.67
WHEN V_RND2 <= 0.845549738219895 THEN ((V_RND2-0.830447039871124)*(1/100)/0.0151026983487716)+0.68
WHEN V_RND2 <= 0.859846959323399 THEN ((V_RND2-0.845549738219895)*(1/100)/0.0142972211035038)+0.69
WHEN V_RND2 <= 0.873540072492952 THEN ((V_RND2-0.859846959323399)*(1/100)/0.013693113169553)+0.7
WHEN V_RND2 <= 0.886629077728554 THEN ((V_RND2-0.873540072492952)*(1/100)/0.0130890052356021)+0.71
WHEN V_RND2 <= 0.898711236407572 THEN ((V_RND2-0.886629077728554)*(1/100)/0.0120821586790173)+0.72
WHEN V_RND2 <= 0.910189287152638 THEN ((V_RND2-0.898711236407572)*(1/100)/0.0114780507450665)+0.73
WHEN V_RND2 <= 0.920861860652437 THEN ((V_RND2-0.910189287152638)*(1/100)/0.0106725734997986)+0.74
WHEN V_RND2 <= 0.930930326218284 THEN ((V_RND2-0.920861860652437)*(1/100)/0.0100684655658478)+0.75
WHEN V_RND2 <= 0.939589206604914 THEN ((V_RND2-0.930930326218284)*(1/100)/0.00865888038662908)+0.76
WHEN V_RND2 <= 0.947442609746275 THEN ((V_RND2-0.939589206604914)*(1/100)/0.00785340314136126)+0.77
WHEN V_RND2 <= 0.954490535642368 THEN ((V_RND2-0.947442609746275)*(1/100)/0.00704792589609344)+0.78
WHEN V_RND2 <= 0.960732984293194 THEN ((V_RND2-0.954490535642368)*(1/100)/0.00624244865082561)+0.79
WHEN V_RND2 <= 0.966371325010069 THEN ((V_RND2-0.960732984293194)*(1/100)/0.00563834071687475)+0.8
WHEN V_RND2 <= 0.971405557792993 THEN ((V_RND2-0.966371325010069)*(1/100)/0.00503423278292388)+0.81
WHEN V_RND2 <= 0.975835682641966 THEN ((V_RND2-0.971405557792993)*(1/100)/0.00443012484897302)+0.82
WHEN V_RND2 <= 0.979661699556988 THEN ((V_RND2-0.975835682641966)*(1/100)/0.00382601691502215)+0.83
WHEN V_RND2 <= 0.982883608538059 THEN ((V_RND2-0.979661699556988)*(1/100)/0.00322190898107128)+0.84
WHEN V_RND2 <= 0.985702778896496 THEN ((V_RND2-0.982883608538059)*(1/100)/0.00281917035843737)+0.85
WHEN V_RND2 <= 0.9881192106323 THEN ((V_RND2-0.985702778896496)*(1/100)/0.00241643173580346)+0.86
WHEN V_RND2 <= 0.990132903745469 THEN ((V_RND2-0.9881192106323)*(1/100)/0.00201369311316955)+0.87
WHEN V_RND2 <= 0.991945227547322 THEN ((V_RND2-0.990132903745469)*(1/100)/0.0018123238018526)+0.88
WHEN V_RND2 <= 0.993556182037858 THEN ((V_RND2-0.991945227547322)*(1/100)/0.00161095449053564)+0.89
WHEN V_RND2 <= 0.994965767217076 THEN ((V_RND2-0.993556182037858)*(1/100)/0.00140958517921869)+0.9
WHEN V_RND2 <= 0.996173983084978 THEN ((V_RND2-0.994965767217076)*(1/100)/0.00120821586790173)+0.91
WHEN V_RND2 <= 0.997180829641563 THEN ((V_RND2-0.996173983084978)*(1/100)/0.00100684655658478)+0.92
WHEN V_RND2 <= 0.997986306886831 THEN ((V_RND2-0.997180829641563)*(1/100)/0.000805477245267821)+0.93
WHEN V_RND2 <= 0.998590414820781 THEN ((V_RND2-0.997986306886831)*(1/100)/0.000604107933950866)+0.94
WHEN V_RND2 <= 0.998993153443415 THEN ((V_RND2-0.998590414820781)*(1/100)/0.000402738622633911)+0.95
WHEN V_RND2 <= 0.999395892066049 THEN ((V_RND2-0.998993153443415)*(1/100)/0.000402738622633911)+0.96
WHEN V_RND2 <= 0.999597261377366 THEN ((V_RND2-0.999395892066049)*(1/100)/0.000201369311316955)+0.97
WHEN V_RND2 <= 0.999798630688683 THEN ((V_RND2-0.999597261377366)*(1/100)/0.000201369311316955)+0.98
WHEN V_RND2 <= 1 THEN ((V_RND2-0.999798630688683)*(1/100)/0.000201369311316955)+0.99 ELSE V_RND2 END
WHEN P_TYPE = 2 THEN /* 역정규분포 */
CASE WHEN V_RND2 <= 0.0201369311316955 THEN ((V_RND2-0)*(1/100)/0.0201369311316955)+0
WHEN V_RND2 <= 0.0400724929520741 THEN ((V_RND2-0.0201369311316955)*(1/100)/0.0199355618203786)+0.01
WHEN V_RND2 <= 0.0600080547724527 THEN ((V_RND2-0.0400724929520741)*(1/100)/0.0199355618203786)+0.02
WHEN V_RND2 <= 0.0797422472815143 THEN ((V_RND2-0.0600080547724527)*(1/100)/0.0197341925090616)+0.03
WHEN V_RND2 <= 0.099275070479259 THEN ((V_RND2-0.0797422472815143)*(1/100)/0.0195328231977447)+0.04
WHEN V_RND2 <= 0.118606524365687 THEN ((V_RND2-0.099275070479259)*(1/100)/0.0193314538864277)+0.05
WHEN V_RND2 <= 0.137736608940797 THEN ((V_RND2-0.118606524365687)*(1/100)/0.0191300845751108)+0.06
WHEN V_RND2 <= 0.156665324204591 THEN ((V_RND2-0.137736608940797)*(1/100)/0.0189287152637938)+0.07
WHEN V_RND2 <= 0.175392670157068 THEN ((V_RND2-0.156665324204591)*(1/100)/0.0187273459524768)+0.08
WHEN V_RND2 <= 0.193918646798228 THEN ((V_RND2-0.175392670157068)*(1/100)/0.0185259766411599)+0.09
WHEN V_RND2 <= 0.212243254128071 THEN ((V_RND2-0.193918646798228)*(1/100)/0.0183246073298429)+0.1
WHEN V_RND2 <= 0.230366492146597 THEN ((V_RND2-0.212243254128071)*(1/100)/0.018123238018526)+0.11
WHEN V_RND2 <= 0.248086991542489 THEN ((V_RND2-0.230366492146597)*(1/100)/0.0177204993958921)+0.12
WHEN V_RND2 <= 0.265404752315747 THEN ((V_RND2-0.248086991542489)*(1/100)/0.0173177607732582)+0.13
WHEN V_RND2 <= 0.282319774466371 THEN ((V_RND2-0.265404752315747)*(1/100)/0.0169150221506242)+0.14
WHEN V_RND2 <= 0.298832057994362 THEN ((V_RND2-0.282319774466371)*(1/100)/0.0165122835279903)+0.15
WHEN V_RND2 <= 0.314941602899718 THEN ((V_RND2-0.298832057994362)*(1/100)/0.0161095449053564)+0.16
WHEN V_RND2 <= 0.330447039871124 THEN ((V_RND2-0.314941602899718)*(1/100)/0.0155054369714056)+0.17
WHEN V_RND2 <= 0.345549738219895 THEN ((V_RND2-0.330447039871124)*(1/100)/0.0151026983487716)+0.18
WHEN V_RND2 <= 0.359846959323399 THEN ((V_RND2-0.345549738219895)*(1/100)/0.0142972211035038)+0.19
WHEN V_RND2 <= 0.373540072492952 THEN ((V_RND2-0.359846959323399)*(1/100)/0.013693113169553)+0.2
WHEN V_RND2 <= 0.386629077728554 THEN ((V_RND2-0.373540072492952)*(1/100)/0.0130890052356021)+0.21
WHEN V_RND2 <= 0.398711236407571 THEN ((V_RND2-0.386629077728554)*(1/100)/0.0120821586790173)+0.22
WHEN V_RND2 <= 0.410189287152638 THEN ((V_RND2-0.398711236407571)*(1/100)/0.0114780507450665)+0.23
WHEN V_RND2 <= 0.420861860652437 THEN ((V_RND2-0.410189287152638)*(1/100)/0.0106725734997986)+0.24
WHEN V_RND2 <= 0.430930326218284 THEN ((V_RND2-0.420861860652437)*(1/100)/0.0100684655658478)+0.25
WHEN V_RND2 <= 0.439589206604913 THEN ((V_RND2-0.430930326218284)*(1/100)/0.00865888038662908)+0.26
WHEN V_RND2 <= 0.447442609746275 THEN ((V_RND2-0.439589206604913)*(1/100)/0.00785340314136126)+0.27
WHEN V_RND2 <= 0.454490535642368 THEN ((V_RND2-0.447442609746275)*(1/100)/0.00704792589609344)+0.28
WHEN V_RND2 <= 0.460732984293194 THEN ((V_RND2-0.454490535642368)*(1/100)/0.00624244865082561)+0.29
WHEN V_RND2 <= 0.466371325010068 THEN ((V_RND2-0.460732984293194)*(1/100)/0.00563834071687475)+0.3
WHEN V_RND2 <= 0.471405557792992 THEN ((V_RND2-0.466371325010068)*(1/100)/0.00503423278292388)+0.31
WHEN V_RND2 <= 0.475835682641965 THEN ((V_RND2-0.471405557792992)*(1/100)/0.00443012484897302)+0.32
WHEN V_RND2 <= 0.479661699556988 THEN ((V_RND2-0.475835682641965)*(1/100)/0.00382601691502215)+0.33
WHEN V_RND2 <= 0.482883608538059 THEN ((V_RND2-0.479661699556988)*(1/100)/0.00322190898107128)+0.34
WHEN V_RND2 <= 0.485702778896496 THEN ((V_RND2-0.482883608538059)*(1/100)/0.00281917035843737)+0.35
WHEN V_RND2 <= 0.4881192106323 THEN ((V_RND2-0.485702778896496)*(1/100)/0.00241643173580346)+0.36
WHEN V_RND2 <= 0.490132903745469 THEN ((V_RND2-0.4881192106323)*(1/100)/0.00201369311316955)+0.37
WHEN V_RND2 <= 0.491945227547322 THEN ((V_RND2-0.490132903745469)*(1/100)/0.0018123238018526)+0.38
WHEN V_RND2 <= 0.493556182037857 THEN ((V_RND2-0.491945227547322)*(1/100)/0.00161095449053564)+0.39
WHEN V_RND2 <= 0.494965767217076 THEN ((V_RND2-0.493556182037857)*(1/100)/0.00140958517921869)+0.4
WHEN V_RND2 <= 0.496173983084978 THEN ((V_RND2-0.494965767217076)*(1/100)/0.00120821586790173)+0.41
WHEN V_RND2 <= 0.497180829641563 THEN ((V_RND2-0.496173983084978)*(1/100)/0.00100684655658478)+0.42
WHEN V_RND2 <= 0.49798630688683 THEN ((V_RND2-0.497180829641563)*(1/100)/0.000805477245267821)+0.43
WHEN V_RND2 <= 0.498590414820781 THEN ((V_RND2-0.49798630688683)*(1/100)/0.000604107933950866)+0.44
WHEN V_RND2 <= 0.498993153443415 THEN ((V_RND2-0.498590414820781)*(1/100)/0.000402738622633911)+0.45
WHEN V_RND2 <= 0.499395892066049 THEN ((V_RND2-0.498993153443415)*(1/100)/0.000402738622633911)+0.46
WHEN V_RND2 <= 0.499597261377366 THEN ((V_RND2-0.499395892066049)*(1/100)/0.000201369311316955)+0.47
WHEN V_RND2 <= 0.499798630688683 THEN ((V_RND2-0.499597261377366)*(1/100)/0.000201369311316955)+0.48
WHEN V_RND2 <= 0.5 THEN ((V_RND2-0.499798630688683)*(1/100)/0.000201369311316955)+0.49
WHEN V_RND2 <= 0.500201369311317 THEN ((V_RND2-0.5)*(1/100)/0.000201369311316955)+0.5
WHEN V_RND2 <= 0.500402738622634 THEN ((V_RND2-0.500201369311317)*(1/100)/0.000201369311316955)+0.51
WHEN V_RND2 <= 0.500604107933951 THEN ((V_RND2-0.500402738622634)*(1/100)/0.000201369311316955)+0.52
WHEN V_RND2 <= 0.501006846556585 THEN ((V_RND2-0.500604107933951)*(1/100)/0.000402738622633911)+0.53
WHEN V_RND2 <= 0.501409585179219 THEN ((V_RND2-0.501006846556585)*(1/100)/0.000402738622633911)+0.54
WHEN V_RND2 <= 0.50201369311317 THEN ((V_RND2-0.501409585179219)*(1/100)/0.000604107933950866)+0.55
WHEN V_RND2 <= 0.502819170358437 THEN ((V_RND2-0.50201369311317)*(1/100)/0.000805477245267821)+0.56
WHEN V_RND2 <= 0.503826016915022 THEN ((V_RND2-0.502819170358437)*(1/100)/0.00100684655658478)+0.57
WHEN V_RND2 <= 0.505034232782924 THEN ((V_RND2-0.503826016915022)*(1/100)/0.00120821586790173)+0.58
WHEN V_RND2 <= 0.506443817962143 THEN ((V_RND2-0.505034232782924)*(1/100)/0.00140958517921869)+0.59
WHEN V_RND2 <= 0.508054772452678 THEN ((V_RND2-0.506443817962143)*(1/100)/0.00161095449053564)+0.6
WHEN V_RND2 <= 0.509867096254531 THEN ((V_RND2-0.508054772452678)*(1/100)/0.0018123238018526)+0.61
WHEN V_RND2 <= 0.511880789367701 THEN ((V_RND2-0.509867096254531)*(1/100)/0.00201369311316955)+0.62
WHEN V_RND2 <= 0.514297221103504 THEN ((V_RND2-0.511880789367701)*(1/100)/0.00241643173580346)+0.63
WHEN V_RND2 <= 0.517116391461941 THEN ((V_RND2-0.514297221103504)*(1/100)/0.00281917035843737)+0.64
WHEN V_RND2 <= 0.520338300443013 THEN ((V_RND2-0.517116391461941)*(1/100)/0.00322190898107128)+0.65
WHEN V_RND2 <= 0.524164317358035 THEN ((V_RND2-0.520338300443013)*(1/100)/0.00382601691502215)+0.66
WHEN V_RND2 <= 0.528594442207008 THEN ((V_RND2-0.524164317358035)*(1/100)/0.00443012484897302)+0.67
WHEN V_RND2 <= 0.533628674989932 THEN ((V_RND2-0.528594442207008)*(1/100)/0.00503423278292388)+0.68
WHEN V_RND2 <= 0.539267015706806 THEN ((V_RND2-0.533628674989932)*(1/100)/0.00563834071687475)+0.69
WHEN V_RND2 <= 0.545509464357632 THEN ((V_RND2-0.539267015706806)*(1/100)/0.00624244865082561)+0.7
WHEN V_RND2 <= 0.552557390253726 THEN ((V_RND2-0.545509464357632)*(1/100)/0.00704792589609344)+0.71
WHEN V_RND2 <= 0.560410793395087 THEN ((V_RND2-0.552557390253726)*(1/100)/0.00785340314136126)+0.72
WHEN V_RND2 <= 0.569069673781716 THEN ((V_RND2-0.560410793395087)*(1/100)/0.00865888038662908)+0.73
WHEN V_RND2 <= 0.579138139347564 THEN ((V_RND2-0.569069673781716)*(1/100)/0.0100684655658478)+0.74
WHEN V_RND2 <= 0.589810712847362 THEN ((V_RND2-0.579138139347564)*(1/100)/0.0106725734997986)+0.75
WHEN V_RND2 <= 0.601288763592429 THEN ((V_RND2-0.589810712847362)*(1/100)/0.0114780507450665)+0.76
WHEN V_RND2 <= 0.613370922271446 THEN ((V_RND2-0.601288763592429)*(1/100)/0.0120821586790173)+0.77
WHEN V_RND2 <= 0.626459927507048 THEN ((V_RND2-0.613370922271446)*(1/100)/0.0130890052356021)+0.78
WHEN V_RND2 <= 0.640153040676601 THEN ((V_RND2-0.626459927507048)*(1/100)/0.013693113169553)+0.79
WHEN V_RND2 <= 0.654450261780105 THEN ((V_RND2-0.640153040676601)*(1/100)/0.0142972211035038)+0.8
WHEN V_RND2 <= 0.669552960128877 THEN ((V_RND2-0.654450261780105)*(1/100)/0.0151026983487716)+0.81
WHEN V_RND2 <= 0.685058397100282 THEN ((V_RND2-0.669552960128877)*(1/100)/0.0155054369714056)+0.82
WHEN V_RND2 <= 0.701167942005639 THEN ((V_RND2-0.685058397100282)*(1/100)/0.0161095449053564)+0.83
WHEN V_RND2 <= 0.717680225533629 THEN ((V_RND2-0.701167942005639)*(1/100)/0.0165122835279903)+0.84
WHEN V_RND2 <= 0.734595247684253 THEN ((V_RND2-0.717680225533629)*(1/100)/0.0169150221506242)+0.85
WHEN V_RND2 <= 0.751913008457511 THEN ((V_RND2-0.734595247684253)*(1/100)/0.0173177607732582)+0.86
WHEN V_RND2 <= 0.769633507853403 THEN ((V_RND2-0.751913008457511)*(1/100)/0.0177204993958921)+0.87
WHEN V_RND2 <= 0.787756745871929 THEN ((V_RND2-0.769633507853403)*(1/100)/0.018123238018526)+0.88
WHEN V_RND2 <= 0.806081353201772 THEN ((V_RND2-0.787756745871929)*(1/100)/0.0183246073298429)+0.89
WHEN V_RND2 <= 0.824607329842932 THEN ((V_RND2-0.806081353201772)*(1/100)/0.0185259766411599)+0.9
WHEN V_RND2 <= 0.843334675795409 THEN ((V_RND2-0.824607329842932)*(1/100)/0.0187273459524768)+0.91
WHEN V_RND2 <= 0.862263391059203 THEN ((V_RND2-0.843334675795409)*(1/100)/0.0189287152637938)+0.92
WHEN V_RND2 <= 0.881393475634314 THEN ((V_RND2-0.862263391059203)*(1/100)/0.0191300845751108)+0.93
WHEN V_RND2 <= 0.900724929520741 THEN ((V_RND2-0.881393475634314)*(1/100)/0.0193314538864277)+0.94
WHEN V_RND2 <= 0.920257752718486 THEN ((V_RND2-0.900724929520741)*(1/100)/0.0195328231977447)+0.95
WHEN V_RND2 <= 0.939991945227548 THEN ((V_RND2-0.920257752718486)*(1/100)/0.0197341925090616)+0.96
WHEN V_RND2 <= 0.959927507047926 THEN ((V_RND2-0.939991945227548)*(1/100)/0.0199355618203786)+0.97
WHEN V_RND2 <= 0.979863068868305 THEN ((V_RND2-0.959927507047926)*(1/100)/0.0199355618203786)+0.98
WHEN V_RND2 <= 1 THEN ((V_RND2-0.979863068868305)*(1/100)/0.0201369311316955)+0.99 ELSE V_RND2 END
WHEN P_TYPE = 3 THEN /* 롱테일 */
CASE WHEN V_RND2 <= 0.0527148128624143 THEN ((V_RND2-0)*(1/100)/0.0527148128624143)+0
WHEN V_RND2 <= 0.10437532946758 THEN ((V_RND2-0.0527148128624143)*(1/100)/0.0516605166051661)+0.01
WHEN V_RND2 <= 0.152345809172377 THEN ((V_RND2-0.10437532946758)*(1/100)/0.0479704797047971)+0.02
WHEN V_RND2 <= 0.196626251976805 THEN ((V_RND2-0.152345809172377)*(1/100)/0.044280442804428)+0.03
WHEN V_RND2 <= 0.237743806009489 THEN ((V_RND2-0.196626251976805)*(1/100)/0.0411175540326832)+0.04
WHEN V_RND2 <= 0.276225619399051 THEN ((V_RND2-0.237743806009489)*(1/100)/0.0384818133895625)+0.05
WHEN V_RND2 <= 0.312071692145493 THEN ((V_RND2-0.276225619399051)*(1/100)/0.0358460727464417)+0.06
WHEN V_RND2 <= 0.345809172377438 THEN ((V_RND2-0.312071692145493)*(1/100)/0.0337374802319452)+0.07
WHEN V_RND2 <= 0.377965208223511 THEN ((V_RND2-0.345809172377438)*(1/100)/0.0321560358460727)+0.08
WHEN V_RND2 <= 0.408539799683711 THEN ((V_RND2-0.377965208223511)*(1/100)/0.0305745914602003)+0.09
WHEN V_RND2 <= 0.437005798629415 THEN ((V_RND2-0.408539799683711)*(1/100)/0.0284659989457037)+0.1
WHEN V_RND2 <= 0.463890353189246 THEN ((V_RND2-0.437005798629415)*(1/100)/0.0268845545598313)+0.11
WHEN V_RND2 <= 0.489193463363205 THEN ((V_RND2-0.463890353189246)*(1/100)/0.0253031101739589)+0.12
WHEN V_RND2 <= 0.512915129151291 THEN ((V_RND2-0.489193463363205)*(1/100)/0.0237216657880865)+0.13
WHEN V_RND2 <= 0.53558249868213 THEN ((V_RND2-0.512915129151291)*(1/100)/0.0226673695308382)+0.14
WHEN V_RND2 <= 0.557195571955719 THEN ((V_RND2-0.53558249868213)*(1/100)/0.0216130732735899)+0.15
WHEN V_RND2 <= 0.577754348972061 THEN ((V_RND2-0.557195571955719)*(1/100)/0.0205587770163416)+0.16
WHEN V_RND2 <= 0.597258829731154 THEN ((V_RND2-0.577754348972061)*(1/100)/0.0195044807590933)+0.17
WHEN V_RND2 <= 0.615709014232999 THEN ((V_RND2-0.597258829731154)*(1/100)/0.018450184501845)+0.18
WHEN V_RND2 <= 0.633104902477596 THEN ((V_RND2-0.615709014232999)*(1/100)/0.0173958882445967)+0.19
WHEN V_RND2 <= 0.649446494464944 THEN ((V_RND2-0.633104902477596)*(1/100)/0.0163415919873484)+0.2
WHEN V_RND2 <= 0.664733790195045 THEN ((V_RND2-0.649446494464944)*(1/100)/0.0152872957301002)+0.21
WHEN V_RND2 <= 0.678966789667896 THEN ((V_RND2-0.664733790195045)*(1/100)/0.0142329994728519)+0.22
WHEN V_RND2 <= 0.6921454928835 THEN ((V_RND2-0.678966789667896)*(1/100)/0.0131787032156036)+0.23
WHEN V_RND2 <= 0.704797047970479 THEN ((V_RND2-0.6921454928835)*(1/100)/0.0126515550869794)+0.24
WHEN V_RND2 <= 0.716921454928835 THEN ((V_RND2-0.704797047970479)*(1/100)/0.0121244069583553)+0.25
WHEN V_RND2 <= 0.728518713758566 THEN ((V_RND2-0.716921454928835)*(1/100)/0.0115972588297312)+0.26
WHEN V_RND2 <= 0.739588824459673 THEN ((V_RND2-0.728518713758566)*(1/100)/0.011070110701107)+0.27
WHEN V_RND2 <= 0.750131787032156 THEN ((V_RND2-0.739588824459673)*(1/100)/0.0105429625724829)+0.28
WHEN V_RND2 <= 0.760147601476014 THEN ((V_RND2-0.750131787032156)*(1/100)/0.0100158144438587)+0.29
WHEN V_RND2 <= 0.770163415919873 THEN ((V_RND2-0.760147601476014)*(1/100)/0.0100158144438587)+0.3
WHEN V_RND2 <= 0.779652082235108 THEN ((V_RND2-0.770163415919873)*(1/100)/0.00948866631523458)+0.31
WHEN V_RND2 <= 0.789140748550342 THEN ((V_RND2-0.779652082235108)*(1/100)/0.00948866631523458)+0.32
WHEN V_RND2 <= 0.798102266736953 THEN ((V_RND2-0.789140748550342)*(1/100)/0.00896151818661044)+0.33
WHEN V_RND2 <= 0.807063784923563 THEN ((V_RND2-0.798102266736953)*(1/100)/0.00896151818661044)+0.34
WHEN V_RND2 <= 0.815498154981549 THEN ((V_RND2-0.807063784923563)*(1/100)/0.00843437005798629)+0.35
WHEN V_RND2 <= 0.823405376910911 THEN ((V_RND2-0.815498154981549)*(1/100)/0.00790722192936215)+0.36
WHEN V_RND2 <= 0.830785450711649 THEN ((V_RND2-0.823405376910911)*(1/100)/0.00738007380073801)+0.37
WHEN V_RND2 <= 0.838165524512387 THEN ((V_RND2-0.830785450711649)*(1/100)/0.00738007380073801)+0.38
WHEN V_RND2 <= 0.845018450184501 THEN ((V_RND2-0.838165524512387)*(1/100)/0.00685292567211386)+0.39
WHEN V_RND2 <= 0.851871375856615 THEN ((V_RND2-0.845018450184501)*(1/100)/0.00685292567211386)+0.4
WHEN V_RND2 <= 0.858197153400105 THEN ((V_RND2-0.851871375856615)*(1/100)/0.00632577754348972)+0.41
WHEN V_RND2 <= 0.864522930943595 THEN ((V_RND2-0.858197153400105)*(1/100)/0.00632577754348972)+0.42
WHEN V_RND2 <= 0.87032156035846 THEN ((V_RND2-0.864522930943595)*(1/100)/0.00579862941486558)+0.43
WHEN V_RND2 <= 0.876120189773326 THEN ((V_RND2-0.87032156035846)*(1/100)/0.00579862941486558)+0.44
WHEN V_RND2 <= 0.881918819188191 THEN ((V_RND2-0.876120189773326)*(1/100)/0.00579862941486558)+0.45
WHEN V_RND2 <= 0.887190300474433 THEN ((V_RND2-0.881918819188191)*(1/100)/0.00527148128624143)+0.46
WHEN V_RND2 <= 0.892461781760674 THEN ((V_RND2-0.887190300474433)*(1/100)/0.00527148128624143)+0.47
WHEN V_RND2 <= 0.897733263046915 THEN ((V_RND2-0.892461781760674)*(1/100)/0.00527148128624143)+0.48
WHEN V_RND2 <= 0.902477596204533 THEN ((V_RND2-0.897733263046915)*(1/100)/0.00474433315761729)+0.49
WHEN V_RND2 <= 0.90722192936215 THEN ((V_RND2-0.902477596204533)*(1/100)/0.00474433315761729)+0.5
WHEN V_RND2 <= 0.911966262519767 THEN ((V_RND2-0.90722192936215)*(1/100)/0.00474433315761729)+0.51
WHEN V_RND2 <= 0.91618344754876 THEN ((V_RND2-0.911966262519767)*(1/100)/0.00421718502899315)+0.52
WHEN V_RND2 <= 0.920400632577754 THEN ((V_RND2-0.91618344754876)*(1/100)/0.00421718502899315)+0.53
WHEN V_RND2 <= 0.924617817606747 THEN ((V_RND2-0.920400632577754)*(1/100)/0.00421718502899315)+0.54
WHEN V_RND2 <= 0.92883500263574 THEN ((V_RND2-0.924617817606747)*(1/100)/0.00421718502899315)+0.55
WHEN V_RND2 <= 0.932525039536109 THEN ((V_RND2-0.92883500263574)*(1/100)/0.003690036900369)+0.56
WHEN V_RND2 <= 0.936215076436478 THEN ((V_RND2-0.932525039536109)*(1/100)/0.003690036900369)+0.57
WHEN V_RND2 <= 0.939905113336847 THEN ((V_RND2-0.936215076436478)*(1/100)/0.003690036900369)+0.58
WHEN V_RND2 <= 0.943595150237216 THEN ((V_RND2-0.939905113336847)*(1/100)/0.003690036900369)+0.59
WHEN V_RND2 <= 0.947285187137585 THEN ((V_RND2-0.943595150237216)*(1/100)/0.003690036900369)+0.6
WHEN V_RND2 <= 0.950448075909329 THEN ((V_RND2-0.947285187137585)*(1/100)/0.00316288877174486)+0.61
WHEN V_RND2 <= 0.953610964681074 THEN ((V_RND2-0.950448075909329)*(1/100)/0.00316288877174486)+0.62
WHEN V_RND2 <= 0.956773853452819 THEN ((V_RND2-0.953610964681074)*(1/100)/0.00316288877174486)+0.63
WHEN V_RND2 <= 0.95940959409594 THEN ((V_RND2-0.956773853452819)*(1/100)/0.00263574064312072)+0.64
WHEN V_RND2 <= 0.962045334739061 THEN ((V_RND2-0.95940959409594)*(1/100)/0.00263574064312072)+0.65
WHEN V_RND2 <= 0.964681075382181 THEN ((V_RND2-0.962045334739061)*(1/100)/0.00263574064312072)+0.66
WHEN V_RND2 <= 0.966789667896678 THEN ((V_RND2-0.964681075382181)*(1/100)/0.00210859251449657)+0.67
WHEN V_RND2 <= 0.968898260411174 THEN ((V_RND2-0.966789667896678)*(1/100)/0.00210859251449657)+0.68
WHEN V_RND2 <= 0.971006852925671 THEN ((V_RND2-0.968898260411174)*(1/100)/0.00210859251449657)+0.69
WHEN V_RND2 <= 0.973115445440167 THEN ((V_RND2-0.971006852925671)*(1/100)/0.00210859251449657)+0.7
WHEN V_RND2 <= 0.975224037954664 THEN ((V_RND2-0.973115445440167)*(1/100)/0.00210859251449657)+0.71
WHEN V_RND2 <= 0.976805482340536 THEN ((V_RND2-0.975224037954664)*(1/100)/0.00158144438587243)+0.72
WHEN V_RND2 <= 0.978386926726409 THEN ((V_RND2-0.976805482340536)*(1/100)/0.00158144438587243)+0.73
WHEN V_RND2 <= 0.979968371112281 THEN ((V_RND2-0.978386926726409)*(1/100)/0.00158144438587243)+0.74
WHEN V_RND2 <= 0.981549815498154 THEN ((V_RND2-0.979968371112281)*(1/100)/0.00158144438587243)+0.75
WHEN V_RND2 <= 0.983131259884026 THEN ((V_RND2-0.981549815498154)*(1/100)/0.00158144438587243)+0.76
WHEN V_RND2 <= 0.984712704269898 THEN ((V_RND2-0.983131259884026)*(1/100)/0.00158144438587243)+0.77
WHEN V_RND2 <= 0.985767000527147 THEN ((V_RND2-0.984712704269898)*(1/100)/0.00105429625724829)+0.78
WHEN V_RND2 <= 0.986821296784395 THEN ((V_RND2-0.985767000527147)*(1/100)/0.00105429625724829)+0.79
WHEN V_RND2 <= 0.987875593041643 THEN ((V_RND2-0.986821296784395)*(1/100)/0.00105429625724829)+0.8
WHEN V_RND2 <= 0.988929889298891 THEN ((V_RND2-0.987875593041643)*(1/100)/0.00105429625724829)+0.81
WHEN V_RND2 <= 0.98998418555614 THEN ((V_RND2-0.988929889298891)*(1/100)/0.00105429625724829)+0.82
WHEN V_RND2 <= 0.991038481813388 THEN ((V_RND2-0.98998418555614)*(1/100)/0.00105429625724829)+0.83
WHEN V_RND2 <= 0.992092778070636 THEN ((V_RND2-0.991038481813388)*(1/100)/0.00105429625724829)+0.84
WHEN V_RND2 <= 0.99261992619926 THEN ((V_RND2-0.992092778070636)*(1/100)/0.000527148128624143)+0.85
WHEN V_RND2 <= 0.993147074327885 THEN ((V_RND2-0.99261992619926)*(1/100)/0.000527148128624143)+0.86
WHEN V_RND2 <= 0.993674222456509 THEN ((V_RND2-0.993147074327885)*(1/100)/0.000527148128624143)+0.87
WHEN V_RND2 <= 0.994201370585133 THEN ((V_RND2-0.993674222456509)*(1/100)/0.000527148128624143)+0.88
WHEN V_RND2 <= 0.994728518713757 THEN ((V_RND2-0.994201370585133)*(1/100)/0.000527148128624143)+0.89
WHEN V_RND2 <= 0.995255666842381 THEN ((V_RND2-0.994728518713757)*(1/100)/0.000527148128624143)+0.9
WHEN V_RND2 <= 0.995782814971005 THEN ((V_RND2-0.995255666842381)*(1/100)/0.000527148128624143)+0.91
WHEN V_RND2 <= 0.996309963099629 THEN ((V_RND2-0.995782814971005)*(1/100)/0.000527148128624143)+0.92
WHEN V_RND2 <= 0.996837111228253 THEN ((V_RND2-0.996309963099629)*(1/100)/0.000527148128624143)+0.93
WHEN V_RND2 <= 0.997364259356877 THEN ((V_RND2-0.996837111228253)*(1/100)/0.000527148128624143)+0.94
WHEN V_RND2 <= 0.997891407485501 THEN ((V_RND2-0.997364259356877)*(1/100)/0.000527148128624143)+0.95
WHEN V_RND2 <= 0.998418555614125 THEN ((V_RND2-0.997891407485501)*(1/100)/0.000527148128624143)+0.96
WHEN V_RND2 <= 0.998945703742749 THEN ((V_RND2-0.998418555614125)*(1/100)/0.000527148128624143)+0.97
WHEN V_RND2 <= 0.999472851871374 THEN ((V_RND2-0.998945703742749)*(1/100)/0.000527148128624143)+0.98
WHEN V_RND2 <= 0.999999999999998 THEN ((V_RND2-0.999472851871374)*(1/100)/0.000527148128624143)+0.99 ELSE V_RND2 END
WHEN P_TYPE = 4 THEN /* 롱헤드 */
CASE WHEN V_RND2 <= 0.000527148128624143 THEN ((V_RND2-0)*(1/100)/0.000527148128624143)+0
WHEN V_RND2 <= 0.00105429625724829 THEN ((V_RND2-0.000527148128624143)*(1/100)/0.000527148128624143)+0.01
WHEN V_RND2 <= 0.00158144438587243 THEN ((V_RND2-0.00105429625724829)*(1/100)/0.000527148128624143)+0.02
WHEN V_RND2 <= 0.00210859251449657 THEN ((V_RND2-0.00158144438587243)*(1/100)/0.000527148128624143)+0.03
WHEN V_RND2 <= 0.00263574064312072 THEN ((V_RND2-0.00210859251449657)*(1/100)/0.000527148128624143)+0.04
WHEN V_RND2 <= 0.00316288877174486 THEN ((V_RND2-0.00263574064312072)*(1/100)/0.000527148128624143)+0.05
WHEN V_RND2 <= 0.003690036900369 THEN ((V_RND2-0.00316288877174486)*(1/100)/0.000527148128624143)+0.06
WHEN V_RND2 <= 0.00421718502899315 THEN ((V_RND2-0.003690036900369)*(1/100)/0.000527148128624143)+0.07
WHEN V_RND2 <= 0.00474433315761729 THEN ((V_RND2-0.00421718502899315)*(1/100)/0.000527148128624143)+0.08
WHEN V_RND2 <= 0.00527148128624143 THEN ((V_RND2-0.00474433315761729)*(1/100)/0.000527148128624143)+0.09
WHEN V_RND2 <= 0.00579862941486558 THEN ((V_RND2-0.00527148128624143)*(1/100)/0.000527148128624143)+0.1
WHEN V_RND2 <= 0.00632577754348972 THEN ((V_RND2-0.00579862941486558)*(1/100)/0.000527148128624143)+0.11
WHEN V_RND2 <= 0.00685292567211386 THEN ((V_RND2-0.00632577754348972)*(1/100)/0.000527148128624143)+0.12
WHEN V_RND2 <= 0.00738007380073801 THEN ((V_RND2-0.00685292567211386)*(1/100)/0.000527148128624143)+0.13
WHEN V_RND2 <= 0.00790722192936215 THEN ((V_RND2-0.00738007380073801)*(1/100)/0.000527148128624143)+0.14
WHEN V_RND2 <= 0.00896151818661044 THEN ((V_RND2-0.00790722192936215)*(1/100)/0.00105429625724829)+0.15
WHEN V_RND2 <= 0.0100158144438587 THEN ((V_RND2-0.00896151818661044)*(1/100)/0.00105429625724829)+0.16
WHEN V_RND2 <= 0.011070110701107 THEN ((V_RND2-0.0100158144438587)*(1/100)/0.00105429625724829)+0.17
WHEN V_RND2 <= 0.0121244069583553 THEN ((V_RND2-0.011070110701107)*(1/100)/0.00105429625724829)+0.18
WHEN V_RND2 <= 0.0131787032156036 THEN ((V_RND2-0.0121244069583553)*(1/100)/0.00105429625724829)+0.19
WHEN V_RND2 <= 0.0142329994728519 THEN ((V_RND2-0.0131787032156036)*(1/100)/0.00105429625724829)+0.2
WHEN V_RND2 <= 0.0152872957301002 THEN ((V_RND2-0.0142329994728519)*(1/100)/0.00105429625724829)+0.21
WHEN V_RND2 <= 0.0168687401159726 THEN ((V_RND2-0.0152872957301002)*(1/100)/0.00158144438587243)+0.22
WHEN V_RND2 <= 0.018450184501845 THEN ((V_RND2-0.0168687401159726)*(1/100)/0.00158144438587243)+0.23
WHEN V_RND2 <= 0.0200316288877174 THEN ((V_RND2-0.018450184501845)*(1/100)/0.00158144438587243)+0.24
WHEN V_RND2 <= 0.0216130732735899 THEN ((V_RND2-0.0200316288877174)*(1/100)/0.00158144438587243)+0.25
WHEN V_RND2 <= 0.0231945176594623 THEN ((V_RND2-0.0216130732735899)*(1/100)/0.00158144438587243)+0.26
WHEN V_RND2 <= 0.0247759620453347 THEN ((V_RND2-0.0231945176594623)*(1/100)/0.00158144438587243)+0.27
WHEN V_RND2 <= 0.0268845545598313 THEN ((V_RND2-0.0247759620453347)*(1/100)/0.00210859251449657)+0.28
WHEN V_RND2 <= 0.0289931470743279 THEN ((V_RND2-0.0268845545598313)*(1/100)/0.00210859251449657)+0.29
WHEN V_RND2 <= 0.0311017395888245 THEN ((V_RND2-0.0289931470743279)*(1/100)/0.00210859251449657)+0.3
WHEN V_RND2 <= 0.033210332103321 THEN ((V_RND2-0.0311017395888245)*(1/100)/0.00210859251449657)+0.31
WHEN V_RND2 <= 0.0353189246178176 THEN ((V_RND2-0.033210332103321)*(1/100)/0.00210859251449657)+0.32
WHEN V_RND2 <= 0.0379546652609383 THEN ((V_RND2-0.0353189246178176)*(1/100)/0.00263574064312072)+0.33
WHEN V_RND2 <= 0.040590405904059 THEN ((V_RND2-0.0379546652609383)*(1/100)/0.00263574064312072)+0.34
WHEN V_RND2 <= 0.0432261465471797 THEN ((V_RND2-0.040590405904059)*(1/100)/0.00263574064312072)+0.35
WHEN V_RND2 <= 0.0463890353189246 THEN ((V_RND2-0.0432261465471797)*(1/100)/0.00316288877174486)+0.36
WHEN V_RND2 <= 0.0495519240906695 THEN ((V_RND2-0.0463890353189246)*(1/100)/0.00316288877174486)+0.37
WHEN V_RND2 <= 0.0527148128624143 THEN ((V_RND2-0.0495519240906695)*(1/100)/0.00316288877174486)+0.38
WHEN V_RND2 <= 0.0564048497627833 THEN ((V_RND2-0.0527148128624143)*(1/100)/0.003690036900369)+0.39
WHEN V_RND2 <= 0.0600948866631523 THEN ((V_RND2-0.0564048497627833)*(1/100)/0.003690036900369)+0.4
WHEN V_RND2 <= 0.0637849235635213 THEN ((V_RND2-0.0600948866631523)*(1/100)/0.003690036900369)+0.41
WHEN V_RND2 <= 0.0674749604638903 THEN ((V_RND2-0.0637849235635213)*(1/100)/0.003690036900369)+0.42
WHEN V_RND2 <= 0.0711649973642594 THEN ((V_RND2-0.0674749604638903)*(1/100)/0.003690036900369)+0.43
WHEN V_RND2 <= 0.0753821823932525 THEN ((V_RND2-0.0711649973642594)*(1/100)/0.00421718502899315)+0.44
WHEN V_RND2 <= 0.0795993674222457 THEN ((V_RND2-0.0753821823932525)*(1/100)/0.00421718502899315)+0.45
WHEN V_RND2 <= 0.0838165524512388 THEN ((V_RND2-0.0795993674222457)*(1/100)/0.00421718502899315)+0.46
WHEN V_RND2 <= 0.088033737480232 THEN ((V_RND2-0.0838165524512388)*(1/100)/0.00421718502899315)+0.47
WHEN V_RND2 <= 0.0927780706378493 THEN ((V_RND2-0.088033737480232)*(1/100)/0.00474433315761729)+0.48
WHEN V_RND2 <= 0.0975224037954666 THEN ((V_RND2-0.0927780706378493)*(1/100)/0.00474433315761729)+0.49
WHEN V_RND2 <= 0.102266736953084 THEN ((V_RND2-0.0975224037954666)*(1/100)/0.00474433315761729)+0.5
WHEN V_RND2 <= 0.107538218239325 THEN ((V_RND2-0.102266736953084)*(1/100)/0.00527148128624143)+0.51
WHEN V_RND2 <= 0.112809699525567 THEN ((V_RND2-0.107538218239325)*(1/100)/0.00527148128624143)+0.52
WHEN V_RND2 <= 0.118081180811808 THEN ((V_RND2-0.112809699525567)*(1/100)/0.00527148128624143)+0.53
WHEN V_RND2 <= 0.123879810226674 THEN ((V_RND2-0.118081180811808)*(1/100)/0.00579862941486558)+0.54
WHEN V_RND2 <= 0.129678439641539 THEN ((V_RND2-0.123879810226674)*(1/100)/0.00579862941486558)+0.55
WHEN V_RND2 <= 0.135477069056405 THEN ((V_RND2-0.129678439641539)*(1/100)/0.00579862941486558)+0.56
WHEN V_RND2 <= 0.141802846599895 THEN ((V_RND2-0.135477069056405)*(1/100)/0.00632577754348972)+0.57
WHEN V_RND2 <= 0.148128624143384 THEN ((V_RND2-0.141802846599895)*(1/100)/0.00632577754348972)+0.58
WHEN V_RND2 <= 0.154981549815498 THEN ((V_RND2-0.148128624143384)*(1/100)/0.00685292567211386)+0.59
WHEN V_RND2 <= 0.161834475487612 THEN ((V_RND2-0.154981549815498)*(1/100)/0.00685292567211386)+0.6
WHEN V_RND2 <= 0.16921454928835 THEN ((V_RND2-0.161834475487612)*(1/100)/0.00738007380073801)+0.61
WHEN V_RND2 <= 0.176594623089088 THEN ((V_RND2-0.16921454928835)*(1/100)/0.00738007380073801)+0.62
WHEN V_RND2 <= 0.18450184501845 THEN ((V_RND2-0.176594623089088)*(1/100)/0.00790722192936215)+0.63
WHEN V_RND2 <= 0.192936215076437 THEN ((V_RND2-0.18450184501845)*(1/100)/0.00843437005798629)+0.64
WHEN V_RND2 <= 0.201897733263047 THEN ((V_RND2-0.192936215076437)*(1/100)/0.00896151818661044)+0.65
WHEN V_RND2 <= 0.210859251449658 THEN ((V_RND2-0.201897733263047)*(1/100)/0.00896151818661044)+0.66
WHEN V_RND2 <= 0.220347917764892 THEN ((V_RND2-0.210859251449658)*(1/100)/0.00948866631523458)+0.67
WHEN V_RND2 <= 0.229836584080127 THEN ((V_RND2-0.220347917764892)*(1/100)/0.00948866631523458)+0.68
WHEN V_RND2 <= 0.239852398523985 THEN ((V_RND2-0.229836584080127)*(1/100)/0.0100158144438587)+0.69
WHEN V_RND2 <= 0.249868212967844 THEN ((V_RND2-0.239852398523985)*(1/100)/0.0100158144438587)+0.7
WHEN V_RND2 <= 0.260411175540327 THEN ((V_RND2-0.249868212967844)*(1/100)/0.0105429625724829)+0.71
WHEN V_RND2 <= 0.271481286241434 THEN ((V_RND2-0.260411175540327)*(1/100)/0.011070110701107)+0.72
WHEN V_RND2 <= 0.283078545071165 THEN ((V_RND2-0.271481286241434)*(1/100)/0.0115972588297312)+0.73
WHEN V_RND2 <= 0.295202952029521 THEN ((V_RND2-0.283078545071165)*(1/100)/0.0121244069583553)+0.74
WHEN V_RND2 <= 0.3078545071165 THEN ((V_RND2-0.295202952029521)*(1/100)/0.0126515550869794)+0.75
WHEN V_RND2 <= 0.321033210332104 THEN ((V_RND2-0.3078545071165)*(1/100)/0.0131787032156036)+0.76
WHEN V_RND2 <= 0.335266209804955 THEN ((V_RND2-0.321033210332104)*(1/100)/0.0142329994728519)+0.77
WHEN V_RND2 <= 0.350553505535056 THEN ((V_RND2-0.335266209804955)*(1/100)/0.0152872957301002)+0.78
WHEN V_RND2 <= 0.366895097522404 THEN ((V_RND2-0.350553505535056)*(1/100)/0.0163415919873484)+0.79
WHEN V_RND2 <= 0.384290985767001 THEN ((V_RND2-0.366895097522404)*(1/100)/0.0173958882445967)+0.8
WHEN V_RND2 <= 0.402741170268846 THEN ((V_RND2-0.384290985767001)*(1/100)/0.018450184501845)+0.81
WHEN V_RND2 <= 0.422245651027939 THEN ((V_RND2-0.402741170268846)*(1/100)/0.0195044807590933)+0.82
WHEN V_RND2 <= 0.442804428044281 THEN ((V_RND2-0.422245651027939)*(1/100)/0.0205587770163416)+0.83
WHEN V_RND2 <= 0.464417501317871 THEN ((V_RND2-0.442804428044281)*(1/100)/0.0216130732735899)+0.84
WHEN V_RND2 <= 0.487084870848709 THEN ((V_RND2-0.464417501317871)*(1/100)/0.0226673695308382)+0.85
WHEN V_RND2 <= 0.510806536636795 THEN ((V_RND2-0.487084870848709)*(1/100)/0.0237216657880865)+0.86
WHEN V_RND2 <= 0.536109646810754 THEN ((V_RND2-0.510806536636795)*(1/100)/0.0253031101739589)+0.87
WHEN V_RND2 <= 0.562994201370585 THEN ((V_RND2-0.536109646810754)*(1/100)/0.0268845545598313)+0.88
WHEN V_RND2 <= 0.591460200316289 THEN ((V_RND2-0.562994201370585)*(1/100)/0.0284659989457037)+0.89
WHEN V_RND2 <= 0.622034791776489 THEN ((V_RND2-0.591460200316289)*(1/100)/0.0305745914602003)+0.9
WHEN V_RND2 <= 0.654190827622562 THEN ((V_RND2-0.622034791776489)*(1/100)/0.0321560358460727)+0.91
WHEN V_RND2 <= 0.687928307854507 THEN ((V_RND2-0.654190827622562)*(1/100)/0.0337374802319452)+0.92
WHEN V_RND2 <= 0.723774380600949 THEN ((V_RND2-0.687928307854507)*(1/100)/0.0358460727464417)+0.93
WHEN V_RND2 <= 0.762256193990512 THEN ((V_RND2-0.723774380600949)*(1/100)/0.0384818133895625)+0.94
WHEN V_RND2 <= 0.803373748023195 THEN ((V_RND2-0.762256193990512)*(1/100)/0.0411175540326832)+0.95
WHEN V_RND2 <= 0.847654190827623 THEN ((V_RND2-0.803373748023195)*(1/100)/0.044280442804428)+0.96
WHEN V_RND2 <= 0.89562467053242 THEN ((V_RND2-0.847654190827623)*(1/100)/0.0479704797047971)+0.97
WHEN V_RND2 <= 0.947285187137586 THEN ((V_RND2-0.89562467053242)*(1/100)/0.0516605166051661)+0.98
WHEN V_RND2 <= 1 THEN ((V_RND2-0.947285187137586)*(1/100)/0.0527148128624143)+0.99 ELSE V_RND2 END
WHEN P_TYPE = 5 THEN /* 정비례 */
CASE WHEN V_RND2 <= 0.000198019801980198 THEN ((V_RND2-0)*(1/100)/0.000198019801980198)+0
WHEN V_RND2 <= 0.000594059405940594 THEN ((V_RND2-0.000198019801980198)*(1/100)/0.000396039603960396)+0.01
WHEN V_RND2 <= 0.00118811881188119 THEN ((V_RND2-0.000594059405940594)*(1/100)/0.000594059405940594)+0.02
WHEN V_RND2 <= 0.00198019801980198 THEN ((V_RND2-0.00118811881188119)*(1/100)/0.000792079207920792)+0.03
WHEN V_RND2 <= 0.00297029702970297 THEN ((V_RND2-0.00198019801980198)*(1/100)/0.00099009900990099)+0.04
WHEN V_RND2 <= 0.00415841584158416 THEN ((V_RND2-0.00297029702970297)*(1/100)/0.00118811881188119)+0.05
WHEN V_RND2 <= 0.00554455445544554 THEN ((V_RND2-0.00415841584158416)*(1/100)/0.00138613861386139)+0.06
WHEN V_RND2 <= 0.00712871287128713 THEN ((V_RND2-0.00554455445544554)*(1/100)/0.00158415841584158)+0.07
WHEN V_RND2 <= 0.00891089108910891 THEN ((V_RND2-0.00712871287128713)*(1/100)/0.00178217821782178)+0.08
WHEN V_RND2 <= 0.0108910891089109 THEN ((V_RND2-0.00891089108910891)*(1/100)/0.00198019801980198)+0.09
WHEN V_RND2 <= 0.0130693069306931 THEN ((V_RND2-0.0108910891089109)*(1/100)/0.00217821782178218)+0.1
WHEN V_RND2 <= 0.0154455445544554 THEN ((V_RND2-0.0130693069306931)*(1/100)/0.00237623762376238)+0.11
WHEN V_RND2 <= 0.018019801980198 THEN ((V_RND2-0.0154455445544554)*(1/100)/0.00257425742574257)+0.12
WHEN V_RND2 <= 0.0207920792079208 THEN ((V_RND2-0.018019801980198)*(1/100)/0.00277227722772277)+0.13
WHEN V_RND2 <= 0.0237623762376238 THEN ((V_RND2-0.0207920792079208)*(1/100)/0.00297029702970297)+0.14
WHEN V_RND2 <= 0.0269306930693069 THEN ((V_RND2-0.0237623762376238)*(1/100)/0.00316831683168317)+0.15
WHEN V_RND2 <= 0.0302970297029703 THEN ((V_RND2-0.0269306930693069)*(1/100)/0.00336633663366337)+0.16
WHEN V_RND2 <= 0.0338613861386139 THEN ((V_RND2-0.0302970297029703)*(1/100)/0.00356435643564356)+0.17
WHEN V_RND2 <= 0.0376237623762376 THEN ((V_RND2-0.0338613861386139)*(1/100)/0.00376237623762376)+0.18
WHEN V_RND2 <= 0.0415841584158416 THEN ((V_RND2-0.0376237623762376)*(1/100)/0.00396039603960396)+0.19
WHEN V_RND2 <= 0.0457425742574257 THEN ((V_RND2-0.0415841584158416)*(1/100)/0.00415841584158416)+0.2
WHEN V_RND2 <= 0.0500990099009901 THEN ((V_RND2-0.0457425742574257)*(1/100)/0.00435643564356436)+0.21
WHEN V_RND2 <= 0.0546534653465347 THEN ((V_RND2-0.0500990099009901)*(1/100)/0.00455445544554455)+0.22
WHEN V_RND2 <= 0.0594059405940594 THEN ((V_RND2-0.0546534653465347)*(1/100)/0.00475247524752475)+0.23
WHEN V_RND2 <= 0.0643564356435644 THEN ((V_RND2-0.0594059405940594)*(1/100)/0.00495049504950495)+0.24
WHEN V_RND2 <= 0.0695049504950495 THEN ((V_RND2-0.0643564356435644)*(1/100)/0.00514851485148515)+0.25
WHEN V_RND2 <= 0.0748514851485149 THEN ((V_RND2-0.0695049504950495)*(1/100)/0.00534653465346535)+0.26
WHEN V_RND2 <= 0.0803960396039604 THEN ((V_RND2-0.0748514851485149)*(1/100)/0.00554455445544554)+0.27
WHEN V_RND2 <= 0.0861386138613862 THEN ((V_RND2-0.0803960396039604)*(1/100)/0.00574257425742574)+0.28
WHEN V_RND2 <= 0.0920792079207921 THEN ((V_RND2-0.0861386138613862)*(1/100)/0.00594059405940594)+0.29
WHEN V_RND2 <= 0.0982178217821782 THEN ((V_RND2-0.0920792079207921)*(1/100)/0.00613861386138614)+0.3
WHEN V_RND2 <= 0.104554455445545 THEN ((V_RND2-0.0982178217821782)*(1/100)/0.00633663366336634)+0.31
WHEN V_RND2 <= 0.111089108910891 THEN ((V_RND2-0.104554455445545)*(1/100)/0.00653465346534653)+0.32
WHEN V_RND2 <= 0.117821782178218 THEN ((V_RND2-0.111089108910891)*(1/100)/0.00673267326732673)+0.33
WHEN V_RND2 <= 0.124752475247525 THEN ((V_RND2-0.117821782178218)*(1/100)/0.00693069306930693)+0.34
WHEN V_RND2 <= 0.131881188118812 THEN ((V_RND2-0.124752475247525)*(1/100)/0.00712871287128713)+0.35
WHEN V_RND2 <= 0.139207920792079 THEN ((V_RND2-0.131881188118812)*(1/100)/0.00732673267326733)+0.36
WHEN V_RND2 <= 0.146732673267327 THEN ((V_RND2-0.139207920792079)*(1/100)/0.00752475247524752)+0.37
WHEN V_RND2 <= 0.154455445544555 THEN ((V_RND2-0.146732673267327)*(1/100)/0.00772277227722772)+0.38
WHEN V_RND2 <= 0.162376237623762 THEN ((V_RND2-0.154455445544555)*(1/100)/0.00792079207920792)+0.39
WHEN V_RND2 <= 0.170495049504951 THEN ((V_RND2-0.162376237623762)*(1/100)/0.00811881188118812)+0.4
WHEN V_RND2 <= 0.178811881188119 THEN ((V_RND2-0.170495049504951)*(1/100)/0.00831683168316832)+0.41
WHEN V_RND2 <= 0.187326732673267 THEN ((V_RND2-0.178811881188119)*(1/100)/0.00851485148514852)+0.42
WHEN V_RND2 <= 0.196039603960396 THEN ((V_RND2-0.187326732673267)*(1/100)/0.00871287128712871)+0.43
WHEN V_RND2 <= 0.204950495049505 THEN ((V_RND2-0.196039603960396)*(1/100)/0.00891089108910891)+0.44
WHEN V_RND2 <= 0.214059405940594 THEN ((V_RND2-0.204950495049505)*(1/100)/0.00910891089108911)+0.45
WHEN V_RND2 <= 0.223366336633664 THEN ((V_RND2-0.214059405940594)*(1/100)/0.00930693069306931)+0.46
WHEN V_RND2 <= 0.232871287128713 THEN ((V_RND2-0.223366336633664)*(1/100)/0.0095049504950495)+0.47
WHEN V_RND2 <= 0.242574257425743 THEN ((V_RND2-0.232871287128713)*(1/100)/0.0097029702970297)+0.48
WHEN V_RND2 <= 0.252475247524753 THEN ((V_RND2-0.242574257425743)*(1/100)/0.0099009900990099)+0.49
WHEN V_RND2 <= 0.262574257425743 THEN ((V_RND2-0.252475247524753)*(1/100)/0.0100990099009901)+0.5
WHEN V_RND2 <= 0.272871287128713 THEN ((V_RND2-0.262574257425743)*(1/100)/0.0102970297029703)+0.51
WHEN V_RND2 <= 0.283366336633664 THEN ((V_RND2-0.272871287128713)*(1/100)/0.0104950495049505)+0.52
WHEN V_RND2 <= 0.294059405940594 THEN ((V_RND2-0.283366336633664)*(1/100)/0.0106930693069307)+0.53
WHEN V_RND2 <= 0.304950495049505 THEN ((V_RND2-0.294059405940594)*(1/100)/0.0108910891089109)+0.54
WHEN V_RND2 <= 0.316039603960396 THEN ((V_RND2-0.304950495049505)*(1/100)/0.0110891089108911)+0.55
WHEN V_RND2 <= 0.327326732673268 THEN ((V_RND2-0.316039603960396)*(1/100)/0.0112871287128713)+0.56
WHEN V_RND2 <= 0.338811881188119 THEN ((V_RND2-0.327326732673268)*(1/100)/0.0114851485148515)+0.57
WHEN V_RND2 <= 0.350495049504951 THEN ((V_RND2-0.338811881188119)*(1/100)/0.0116831683168317)+0.58
WHEN V_RND2 <= 0.362376237623763 THEN ((V_RND2-0.350495049504951)*(1/100)/0.0118811881188119)+0.59
WHEN V_RND2 <= 0.374455445544555 THEN ((V_RND2-0.362376237623763)*(1/100)/0.0120792079207921)+0.6
WHEN V_RND2 <= 0.386732673267327 THEN ((V_RND2-0.374455445544555)*(1/100)/0.0122772277227723)+0.61
WHEN V_RND2 <= 0.39920792079208 THEN ((V_RND2-0.386732673267327)*(1/100)/0.0124752475247525)+0.62
WHEN V_RND2 <= 0.411881188118812 THEN ((V_RND2-0.39920792079208)*(1/100)/0.0126732673267327)+0.63
WHEN V_RND2 <= 0.424752475247525 THEN ((V_RND2-0.411881188118812)*(1/100)/0.0128712871287129)+0.64
WHEN V_RND2 <= 0.437821782178218 THEN ((V_RND2-0.424752475247525)*(1/100)/0.0130693069306931)+0.65
WHEN V_RND2 <= 0.451089108910891 THEN ((V_RND2-0.437821782178218)*(1/100)/0.0132673267326733)+0.66
WHEN V_RND2 <= 0.464554455445545 THEN ((V_RND2-0.451089108910891)*(1/100)/0.0134653465346535)+0.67
WHEN V_RND2 <= 0.478217821782179 THEN ((V_RND2-0.464554455445545)*(1/100)/0.0136633663366337)+0.68
WHEN V_RND2 <= 0.492079207920792 THEN ((V_RND2-0.478217821782179)*(1/100)/0.0138613861386139)+0.69
WHEN V_RND2 <= 0.506138613861386 THEN ((V_RND2-0.492079207920792)*(1/100)/0.0140594059405941)+0.7
WHEN V_RND2 <= 0.520396039603961 THEN ((V_RND2-0.506138613861386)*(1/100)/0.0142574257425743)+0.71
WHEN V_RND2 <= 0.534851485148515 THEN ((V_RND2-0.520396039603961)*(1/100)/0.0144554455445545)+0.72
WHEN V_RND2 <= 0.54950495049505 THEN ((V_RND2-0.534851485148515)*(1/100)/0.0146534653465347)+0.73
WHEN V_RND2 <= 0.564356435643565 THEN ((V_RND2-0.54950495049505)*(1/100)/0.0148514851485149)+0.74
WHEN V_RND2 <= 0.57940594059406 THEN ((V_RND2-0.564356435643565)*(1/100)/0.015049504950495)+0.75
WHEN V_RND2 <= 0.594653465346535 THEN ((V_RND2-0.57940594059406)*(1/100)/0.0152475247524752)+0.76
WHEN V_RND2 <= 0.610099009900991 THEN ((V_RND2-0.594653465346535)*(1/100)/0.0154455445544554)+0.77
WHEN V_RND2 <= 0.625742574257426 THEN ((V_RND2-0.610099009900991)*(1/100)/0.0156435643564356)+0.78
WHEN V_RND2 <= 0.641584158415842 THEN ((V_RND2-0.625742574257426)*(1/100)/0.0158415841584158)+0.79
WHEN V_RND2 <= 0.657623762376238 THEN ((V_RND2-0.641584158415842)*(1/100)/0.016039603960396)+0.8
WHEN V_RND2 <= 0.673861386138614 THEN ((V_RND2-0.657623762376238)*(1/100)/0.0162376237623762)+0.81
WHEN V_RND2 <= 0.690297029702971 THEN ((V_RND2-0.673861386138614)*(1/100)/0.0164356435643564)+0.82
WHEN V_RND2 <= 0.706930693069307 THEN ((V_RND2-0.690297029702971)*(1/100)/0.0166336633663366)+0.83
WHEN V_RND2 <= 0.723762376237624 THEN ((V_RND2-0.706930693069307)*(1/100)/0.0168316831683168)+0.84
WHEN V_RND2 <= 0.740792079207921 THEN ((V_RND2-0.723762376237624)*(1/100)/0.017029702970297)+0.85
WHEN V_RND2 <= 0.758019801980199 THEN ((V_RND2-0.740792079207921)*(1/100)/0.0172277227722772)+0.86
WHEN V_RND2 <= 0.775445544554456 THEN ((V_RND2-0.758019801980199)*(1/100)/0.0174257425742574)+0.87
WHEN V_RND2 <= 0.793069306930694 THEN ((V_RND2-0.775445544554456)*(1/100)/0.0176237623762376)+0.88
WHEN V_RND2 <= 0.810891089108912 THEN ((V_RND2-0.793069306930694)*(1/100)/0.0178217821782178)+0.89
WHEN V_RND2 <= 0.82891089108911 THEN ((V_RND2-0.810891089108912)*(1/100)/0.018019801980198)+0.9
WHEN V_RND2 <= 0.847128712871288 THEN ((V_RND2-0.82891089108911)*(1/100)/0.0182178217821782)+0.91
WHEN V_RND2 <= 0.865544554455446 THEN ((V_RND2-0.847128712871288)*(1/100)/0.0184158415841584)+0.92
WHEN V_RND2 <= 0.884158415841585 THEN ((V_RND2-0.865544554455446)*(1/100)/0.0186138613861386)+0.93
WHEN V_RND2 <= 0.902970297029704 THEN ((V_RND2-0.884158415841585)*(1/100)/0.0188118811881188)+0.94
WHEN V_RND2 <= 0.921980198019803 THEN ((V_RND2-0.902970297029704)*(1/100)/0.019009900990099)+0.95
WHEN V_RND2 <= 0.941188118811882 THEN ((V_RND2-0.921980198019803)*(1/100)/0.0192079207920792)+0.96
WHEN V_RND2 <= 0.960594059405941 THEN ((V_RND2-0.941188118811882)*(1/100)/0.0194059405940594)+0.97
WHEN V_RND2 <= 0.980198019801981 THEN ((V_RND2-0.960594059405941)*(1/100)/0.0196039603960396)+0.98
WHEN V_RND2 <= 1 THEN ((V_RND2-0.980198019801981)*(1/100)/0.0198019801980198)+0.99 ELSE V_RND2 END
WHEN P_TYPE = 6 THEN /* 역비례 */
CASE WHEN V_RND2 <= 0.0198019801980198 THEN ((V_RND2-0)*(1/100)/0.0198019801980198)+0
WHEN V_RND2 <= 0.0394059405940594 THEN ((V_RND2-0.0198019801980198)*(1/100)/0.0196039603960396)+0.01
WHEN V_RND2 <= 0.0588118811881188 THEN ((V_RND2-0.0394059405940594)*(1/100)/0.0194059405940594)+0.02
WHEN V_RND2 <= 0.078019801980198 THEN ((V_RND2-0.0588118811881188)*(1/100)/0.0192079207920792)+0.03
WHEN V_RND2 <= 0.097029702970297 THEN ((V_RND2-0.078019801980198)*(1/100)/0.019009900990099)+0.04
WHEN V_RND2 <= 0.115841584158416 THEN ((V_RND2-0.097029702970297)*(1/100)/0.0188118811881188)+0.05
WHEN V_RND2 <= 0.134455445544554 THEN ((V_RND2-0.115841584158416)*(1/100)/0.0186138613861386)+0.06
WHEN V_RND2 <= 0.152871287128713 THEN ((V_RND2-0.134455445544554)*(1/100)/0.0184158415841584)+0.07
WHEN V_RND2 <= 0.171089108910891 THEN ((V_RND2-0.152871287128713)*(1/100)/0.0182178217821782)+0.08
WHEN V_RND2 <= 0.189108910891089 THEN ((V_RND2-0.171089108910891)*(1/100)/0.018019801980198)+0.09
WHEN V_RND2 <= 0.206930693069307 THEN ((V_RND2-0.189108910891089)*(1/100)/0.0178217821782178)+0.1
WHEN V_RND2 <= 0.224554455445545 THEN ((V_RND2-0.206930693069307)*(1/100)/0.0176237623762376)+0.11
WHEN V_RND2 <= 0.241980198019802 THEN ((V_RND2-0.224554455445545)*(1/100)/0.0174257425742574)+0.12
WHEN V_RND2 <= 0.259207920792079 THEN ((V_RND2-0.241980198019802)*(1/100)/0.0172277227722772)+0.13
WHEN V_RND2 <= 0.276237623762376 THEN ((V_RND2-0.259207920792079)*(1/100)/0.017029702970297)+0.14
WHEN V_RND2 <= 0.293069306930693 THEN ((V_RND2-0.276237623762376)*(1/100)/0.0168316831683168)+0.15
WHEN V_RND2 <= 0.30970297029703 THEN ((V_RND2-0.293069306930693)*(1/100)/0.0166336633663366)+0.16
WHEN V_RND2 <= 0.326138613861386 THEN ((V_RND2-0.30970297029703)*(1/100)/0.0164356435643564)+0.17
WHEN V_RND2 <= 0.342376237623762 THEN ((V_RND2-0.326138613861386)*(1/100)/0.0162376237623762)+0.18
WHEN V_RND2 <= 0.358415841584158 THEN ((V_RND2-0.342376237623762)*(1/100)/0.016039603960396)+0.19
WHEN V_RND2 <= 0.374257425742574 THEN ((V_RND2-0.358415841584158)*(1/100)/0.0158415841584158)+0.2
WHEN V_RND2 <= 0.38990099009901 THEN ((V_RND2-0.374257425742574)*(1/100)/0.0156435643564356)+0.21
WHEN V_RND2 <= 0.405346534653465 THEN ((V_RND2-0.38990099009901)*(1/100)/0.0154455445544554)+0.22
WHEN V_RND2 <= 0.420594059405941 THEN ((V_RND2-0.405346534653465)*(1/100)/0.0152475247524752)+0.23
WHEN V_RND2 <= 0.435643564356436 THEN ((V_RND2-0.420594059405941)*(1/100)/0.015049504950495)+0.24
WHEN V_RND2 <= 0.450495049504951 THEN ((V_RND2-0.435643564356436)*(1/100)/0.0148514851485149)+0.25
WHEN V_RND2 <= 0.465148514851485 THEN ((V_RND2-0.450495049504951)*(1/100)/0.0146534653465347)+0.26
WHEN V_RND2 <= 0.47960396039604 THEN ((V_RND2-0.465148514851485)*(1/100)/0.0144554455445545)+0.27
WHEN V_RND2 <= 0.493861386138614 THEN ((V_RND2-0.47960396039604)*(1/100)/0.0142574257425743)+0.28
WHEN V_RND2 <= 0.507920792079208 THEN ((V_RND2-0.493861386138614)*(1/100)/0.0140594059405941)+0.29
WHEN V_RND2 <= 0.521782178217822 THEN ((V_RND2-0.507920792079208)*(1/100)/0.0138613861386139)+0.3
WHEN V_RND2 <= 0.535445544554456 THEN ((V_RND2-0.521782178217822)*(1/100)/0.0136633663366337)+0.31
WHEN V_RND2 <= 0.548910891089109 THEN ((V_RND2-0.535445544554456)*(1/100)/0.0134653465346535)+0.32
WHEN V_RND2 <= 0.562178217821782 THEN ((V_RND2-0.548910891089109)*(1/100)/0.0132673267326733)+0.33
WHEN V_RND2 <= 0.575247524752475 THEN ((V_RND2-0.562178217821782)*(1/100)/0.0130693069306931)+0.34
WHEN V_RND2 <= 0.588118811881188 THEN ((V_RND2-0.575247524752475)*(1/100)/0.0128712871287129)+0.35
WHEN V_RND2 <= 0.600792079207921 THEN ((V_RND2-0.588118811881188)*(1/100)/0.0126732673267327)+0.36
WHEN V_RND2 <= 0.613267326732673 THEN ((V_RND2-0.600792079207921)*(1/100)/0.0124752475247525)+0.37
WHEN V_RND2 <= 0.625544554455446 THEN ((V_RND2-0.613267326732673)*(1/100)/0.0122772277227723)+0.38
WHEN V_RND2 <= 0.637623762376238 THEN ((V_RND2-0.625544554455446)*(1/100)/0.0120792079207921)+0.39
WHEN V_RND2 <= 0.64950495049505 THEN ((V_RND2-0.637623762376238)*(1/100)/0.0118811881188119)+0.4
WHEN V_RND2 <= 0.661188118811881 THEN ((V_RND2-0.64950495049505)*(1/100)/0.0116831683168317)+0.41
WHEN V_RND2 <= 0.672673267326733 THEN ((V_RND2-0.661188118811881)*(1/100)/0.0114851485148515)+0.42
WHEN V_RND2 <= 0.683960396039604 THEN ((V_RND2-0.672673267326733)*(1/100)/0.0112871287128713)+0.43
WHEN V_RND2 <= 0.695049504950495 THEN ((V_RND2-0.683960396039604)*(1/100)/0.0110891089108911)+0.44
WHEN V_RND2 <= 0.705940594059406 THEN ((V_RND2-0.695049504950495)*(1/100)/0.0108910891089109)+0.45
WHEN V_RND2 <= 0.716633663366337 THEN ((V_RND2-0.705940594059406)*(1/100)/0.0106930693069307)+0.46
WHEN V_RND2 <= 0.727128712871287 THEN ((V_RND2-0.716633663366337)*(1/100)/0.0104950495049505)+0.47
WHEN V_RND2 <= 0.737425742574258 THEN ((V_RND2-0.727128712871287)*(1/100)/0.0102970297029703)+0.48
WHEN V_RND2 <= 0.747524752475248 THEN ((V_RND2-0.737425742574258)*(1/100)/0.0100990099009901)+0.49
WHEN V_RND2 <= 0.757425742574258 THEN ((V_RND2-0.747524752475248)*(1/100)/0.0099009900990099)+0.5
WHEN V_RND2 <= 0.767128712871287 THEN ((V_RND2-0.757425742574258)*(1/100)/0.0097029702970297)+0.51
WHEN V_RND2 <= 0.776633663366337 THEN ((V_RND2-0.767128712871287)*(1/100)/0.0095049504950495)+0.52
WHEN V_RND2 <= 0.785940594059406 THEN ((V_RND2-0.776633663366337)*(1/100)/0.00930693069306931)+0.53
WHEN V_RND2 <= 0.795049504950495 THEN ((V_RND2-0.785940594059406)*(1/100)/0.00910891089108911)+0.54
WHEN V_RND2 <= 0.803960396039604 THEN ((V_RND2-0.795049504950495)*(1/100)/0.00891089108910891)+0.55
WHEN V_RND2 <= 0.812673267326733 THEN ((V_RND2-0.803960396039604)*(1/100)/0.00871287128712871)+0.56
WHEN V_RND2 <= 0.821188118811882 THEN ((V_RND2-0.812673267326733)*(1/100)/0.00851485148514852)+0.57
WHEN V_RND2 <= 0.82950495049505 THEN ((V_RND2-0.821188118811882)*(1/100)/0.00831683168316832)+0.58
WHEN V_RND2 <= 0.837623762376238 THEN ((V_RND2-0.82950495049505)*(1/100)/0.00811881188118812)+0.59
WHEN V_RND2 <= 0.845544554455446 THEN ((V_RND2-0.837623762376238)*(1/100)/0.00792079207920792)+0.6
WHEN V_RND2 <= 0.853267326732674 THEN ((V_RND2-0.845544554455446)*(1/100)/0.00772277227722772)+0.61
WHEN V_RND2 <= 0.860792079207921 THEN ((V_RND2-0.853267326732674)*(1/100)/0.00752475247524752)+0.62
WHEN V_RND2 <= 0.868118811881189 THEN ((V_RND2-0.860792079207921)*(1/100)/0.00732673267326733)+0.63
WHEN V_RND2 <= 0.875247524752476 THEN ((V_RND2-0.868118811881189)*(1/100)/0.00712871287128713)+0.64
WHEN V_RND2 <= 0.882178217821783 THEN ((V_RND2-0.875247524752476)*(1/100)/0.00693069306930693)+0.65
WHEN V_RND2 <= 0.888910891089109 THEN ((V_RND2-0.882178217821783)*(1/100)/0.00673267326732673)+0.66
WHEN V_RND2 <= 0.895445544554456 THEN ((V_RND2-0.888910891089109)*(1/100)/0.00653465346534653)+0.67
WHEN V_RND2 <= 0.901782178217822 THEN ((V_RND2-0.895445544554456)*(1/100)/0.00633663366336634)+0.68
WHEN V_RND2 <= 0.907920792079208 THEN ((V_RND2-0.901782178217822)*(1/100)/0.00613861386138614)+0.69
WHEN V_RND2 <= 0.913861386138614 THEN ((V_RND2-0.907920792079208)*(1/100)/0.00594059405940594)+0.7
WHEN V_RND2 <= 0.91960396039604 THEN ((V_RND2-0.913861386138614)*(1/100)/0.00574257425742574)+0.71
WHEN V_RND2 <= 0.925148514851486 THEN ((V_RND2-0.91960396039604)*(1/100)/0.00554455445544554)+0.72
WHEN V_RND2 <= 0.930495049504951 THEN ((V_RND2-0.925148514851486)*(1/100)/0.00534653465346535)+0.73
WHEN V_RND2 <= 0.935643564356436 THEN ((V_RND2-0.930495049504951)*(1/100)/0.00514851485148515)+0.74
WHEN V_RND2 <= 0.940594059405941 THEN ((V_RND2-0.935643564356436)*(1/100)/0.00495049504950495)+0.75
WHEN V_RND2 <= 0.945346534653466 THEN ((V_RND2-0.940594059405941)*(1/100)/0.00475247524752475)+0.76
WHEN V_RND2 <= 0.94990099009901 THEN ((V_RND2-0.945346534653466)*(1/100)/0.00455445544554455)+0.77
WHEN V_RND2 <= 0.954257425742575 THEN ((V_RND2-0.94990099009901)*(1/100)/0.00435643564356436)+0.78
WHEN V_RND2 <= 0.958415841584159 THEN ((V_RND2-0.954257425742575)*(1/100)/0.00415841584158416)+0.79
WHEN V_RND2 <= 0.962376237623763 THEN ((V_RND2-0.958415841584159)*(1/100)/0.00396039603960396)+0.8
WHEN V_RND2 <= 0.966138613861387 THEN ((V_RND2-0.962376237623763)*(1/100)/0.00376237623762376)+0.81
WHEN V_RND2 <= 0.96970297029703 THEN ((V_RND2-0.966138613861387)*(1/100)/0.00356435643564356)+0.82
WHEN V_RND2 <= 0.973069306930694 THEN ((V_RND2-0.96970297029703)*(1/100)/0.00336633663366337)+0.83
WHEN V_RND2 <= 0.976237623762377 THEN ((V_RND2-0.973069306930694)*(1/100)/0.00316831683168317)+0.84
WHEN V_RND2 <= 0.97920792079208 THEN ((V_RND2-0.976237623762377)*(1/100)/0.00297029702970297)+0.85
WHEN V_RND2 <= 0.981980198019803 THEN ((V_RND2-0.97920792079208)*(1/100)/0.00277227722772277)+0.86
WHEN V_RND2 <= 0.984554455445545 THEN ((V_RND2-0.981980198019803)*(1/100)/0.00257425742574257)+0.87
WHEN V_RND2 <= 0.986930693069307 THEN ((V_RND2-0.984554455445545)*(1/100)/0.00237623762376238)+0.88
WHEN V_RND2 <= 0.98910891089109 THEN ((V_RND2-0.986930693069307)*(1/100)/0.00217821782178218)+0.89
WHEN V_RND2 <= 0.991089108910892 THEN ((V_RND2-0.98910891089109)*(1/100)/0.00198019801980198)+0.9
WHEN V_RND2 <= 0.992871287128713 THEN ((V_RND2-0.991089108910892)*(1/100)/0.00178217821782178)+0.91
WHEN V_RND2 <= 0.994455445544555 THEN ((V_RND2-0.992871287128713)*(1/100)/0.00158415841584158)+0.92
WHEN V_RND2 <= 0.995841584158416 THEN ((V_RND2-0.994455445544555)*(1/100)/0.00138613861386139)+0.93
WHEN V_RND2 <= 0.997029702970298 THEN ((V_RND2-0.995841584158416)*(1/100)/0.00118811881188119)+0.94
WHEN V_RND2 <= 0.998019801980199 THEN ((V_RND2-0.997029702970298)*(1/100)/0.00099009900990099)+0.95
WHEN V_RND2 <= 0.998811881188119 THEN ((V_RND2-0.998019801980199)*(1/100)/0.000792079207920792)+0.96
WHEN V_RND2 <= 0.99940594059406 THEN ((V_RND2-0.998811881188119)*(1/100)/0.000594059405940594)+0.97
WHEN V_RND2 <= 0.99980198019802 THEN ((V_RND2-0.99940594059406)*(1/100)/0.000396039603960396)+0.98
WHEN V_RND2 <= 1 THEN ((V_RND2-0.99980198019802)*(1/100)/0.000198019801980198)+0.99 ELSE V_RND2 END
WHEN P_TYPE = 7 THEN /* 증가 */
CASE WHEN V_RND2 <= 0.000324359390204346 THEN ((V_RND2-0)*(1/100)/0.000324359390204346)+0
WHEN V_RND2 <= 0.000648718780408693 THEN ((V_RND2-0.000324359390204346)*(1/100)/0.000324359390204346)+0.01
WHEN V_RND2 <= 0.000973078170613039 THEN ((V_RND2-0.000648718780408693)*(1/100)/0.000324359390204346)+0.02
WHEN V_RND2 <= 0.00129743756081739 THEN ((V_RND2-0.000973078170613039)*(1/100)/0.000324359390204346)+0.03
WHEN V_RND2 <= 0.00162179695102173 THEN ((V_RND2-0.00129743756081739)*(1/100)/0.000324359390204346)+0.04
WHEN V_RND2 <= 0.00194615634122608 THEN ((V_RND2-0.00162179695102173)*(1/100)/0.000324359390204346)+0.05
WHEN V_RND2 <= 0.00227051573143042 THEN ((V_RND2-0.00194615634122608)*(1/100)/0.000324359390204346)+0.06
WHEN V_RND2 <= 0.00259487512163477 THEN ((V_RND2-0.00227051573143042)*(1/100)/0.000324359390204346)+0.07
WHEN V_RND2 <= 0.00291923451183912 THEN ((V_RND2-0.00259487512163477)*(1/100)/0.000324359390204346)+0.08
WHEN V_RND2 <= 0.00324359390204346 THEN ((V_RND2-0.00291923451183912)*(1/100)/0.000324359390204346)+0.09
WHEN V_RND2 <= 0.00356795329224781 THEN ((V_RND2-0.00324359390204346)*(1/100)/0.000324359390204346)+0.1
WHEN V_RND2 <= 0.00389231268245216 THEN ((V_RND2-0.00356795329224781)*(1/100)/0.000324359390204346)+0.11
WHEN V_RND2 <= 0.0042166720726565 THEN ((V_RND2-0.00389231268245216)*(1/100)/0.000324359390204346)+0.12
WHEN V_RND2 <= 0.00454103146286085 THEN ((V_RND2-0.0042166720726565)*(1/100)/0.000324359390204346)+0.13
WHEN V_RND2 <= 0.0048653908530652 THEN ((V_RND2-0.00454103146286085)*(1/100)/0.000324359390204346)+0.14
WHEN V_RND2 <= 0.00551410963347389 THEN ((V_RND2-0.0048653908530652)*(1/100)/0.000648718780408693)+0.15
WHEN V_RND2 <= 0.00616282841388258 THEN ((V_RND2-0.00551410963347389)*(1/100)/0.000648718780408693)+0.16
WHEN V_RND2 <= 0.00681154719429127 THEN ((V_RND2-0.00616282841388258)*(1/100)/0.000648718780408693)+0.17
WHEN V_RND2 <= 0.00746026597469997 THEN ((V_RND2-0.00681154719429127)*(1/100)/0.000648718780408693)+0.18
WHEN V_RND2 <= 0.00810898475510866 THEN ((V_RND2-0.00746026597469997)*(1/100)/0.000648718780408693)+0.19
WHEN V_RND2 <= 0.0090820629257217 THEN ((V_RND2-0.00810898475510866)*(1/100)/0.000973078170613039)+0.2
WHEN V_RND2 <= 0.0100551410963347 THEN ((V_RND2-0.0090820629257217)*(1/100)/0.000973078170613039)+0.21
WHEN V_RND2 <= 0.0110282192669478 THEN ((V_RND2-0.0100551410963347)*(1/100)/0.000973078170613039)+0.22
WHEN V_RND2 <= 0.0123256568277652 THEN ((V_RND2-0.0110282192669478)*(1/100)/0.00129743756081739)+0.23
WHEN V_RND2 <= 0.0136230943885826 THEN ((V_RND2-0.0123256568277652)*(1/100)/0.00129743756081739)+0.24
WHEN V_RND2 <= 0.0149205319493999 THEN ((V_RND2-0.0136230943885826)*(1/100)/0.00129743756081739)+0.25
WHEN V_RND2 <= 0.0165423289004217 THEN ((V_RND2-0.0149205319493999)*(1/100)/0.00162179695102173)+0.26
WHEN V_RND2 <= 0.0181641258514434 THEN ((V_RND2-0.0165423289004217)*(1/100)/0.00162179695102173)+0.27
WHEN V_RND2 <= 0.0197859228024651 THEN ((V_RND2-0.0181641258514434)*(1/100)/0.00162179695102173)+0.28
WHEN V_RND2 <= 0.0217320791436912 THEN ((V_RND2-0.0197859228024651)*(1/100)/0.00194615634122608)+0.29
WHEN V_RND2 <= 0.0236782354849173 THEN ((V_RND2-0.0217320791436912)*(1/100)/0.00194615634122608)+0.3
WHEN V_RND2 <= 0.0259487512163477 THEN ((V_RND2-0.0236782354849173)*(1/100)/0.00227051573143042)+0.31
WHEN V_RND2 <= 0.0282192669477781 THEN ((V_RND2-0.0259487512163477)*(1/100)/0.00227051573143042)+0.32
WHEN V_RND2 <= 0.0308141420694129 THEN ((V_RND2-0.0282192669477781)*(1/100)/0.00259487512163477)+0.33
WHEN V_RND2 <= 0.0334090171910477 THEN ((V_RND2-0.0308141420694129)*(1/100)/0.00259487512163477)+0.34
WHEN V_RND2 <= 0.0363282517028868 THEN ((V_RND2-0.0334090171910477)*(1/100)/0.00291923451183912)+0.35
WHEN V_RND2 <= 0.0392474862147259 THEN ((V_RND2-0.0363282517028868)*(1/100)/0.00291923451183912)+0.36
WHEN V_RND2 <= 0.0424910801167694 THEN ((V_RND2-0.0392474862147259)*(1/100)/0.00324359390204346)+0.37
WHEN V_RND2 <= 0.0457346740188129 THEN ((V_RND2-0.0424910801167694)*(1/100)/0.00324359390204346)+0.38
WHEN V_RND2 <= 0.0493026273110607 THEN ((V_RND2-0.0457346740188129)*(1/100)/0.00356795329224781)+0.39
WHEN V_RND2 <= 0.0531949399935128 THEN ((V_RND2-0.0493026273110607)*(1/100)/0.00389231268245216)+0.4
WHEN V_RND2 <= 0.0574116120661693 THEN ((V_RND2-0.0531949399935128)*(1/100)/0.0042166720726565)+0.41
WHEN V_RND2 <= 0.0619526435290302 THEN ((V_RND2-0.0574116120661693)*(1/100)/0.00454103146286085)+0.42
WHEN V_RND2 <= 0.066493674991891 THEN ((V_RND2-0.0619526435290302)*(1/100)/0.00454103146286085)+0.43
WHEN V_RND2 <= 0.0713590658449562 THEN ((V_RND2-0.066493674991891)*(1/100)/0.0048653908530652)+0.44
WHEN V_RND2 <= 0.0765488160882258 THEN ((V_RND2-0.0713590658449562)*(1/100)/0.00518975024326954)+0.45
WHEN V_RND2 <= 0.0820629257216996 THEN ((V_RND2-0.0765488160882258)*(1/100)/0.00551410963347389)+0.46
WHEN V_RND2 <= 0.0879013947453779 THEN ((V_RND2-0.0820629257216996)*(1/100)/0.00583846902367824)+0.47
WHEN V_RND2 <= 0.0940642231592605 THEN ((V_RND2-0.0879013947453779)*(1/100)/0.00616282841388258)+0.48
WHEN V_RND2 <= 0.100551410963347 THEN ((V_RND2-0.0940642231592605)*(1/100)/0.00648718780408693)+0.49
WHEN V_RND2 <= 0.107362958157639 THEN ((V_RND2-0.100551410963347)*(1/100)/0.00681154719429127)+0.5
WHEN V_RND2 <= 0.114498864742134 THEN ((V_RND2-0.107362958157639)*(1/100)/0.00713590658449562)+0.51
WHEN V_RND2 <= 0.121959130716834 THEN ((V_RND2-0.114498864742134)*(1/100)/0.00746026597469997)+0.52
WHEN V_RND2 <= 0.129743756081739 THEN ((V_RND2-0.121959130716834)*(1/100)/0.00778462536490431)+0.53
WHEN V_RND2 <= 0.137852740836847 THEN ((V_RND2-0.129743756081739)*(1/100)/0.00810898475510866)+0.54
WHEN V_RND2 <= 0.14628608498216 THEN ((V_RND2-0.137852740836847)*(1/100)/0.00843334414531301)+0.55
WHEN V_RND2 <= 0.155043788517678 THEN ((V_RND2-0.14628608498216)*(1/100)/0.00875770353551735)+0.56
WHEN V_RND2 <= 0.164125851443399 THEN ((V_RND2-0.155043788517678)*(1/100)/0.0090820629257217)+0.57
WHEN V_RND2 <= 0.17385663314953 THEN ((V_RND2-0.164125851443399)*(1/100)/0.00973078170613039)+0.58
WHEN V_RND2 <= 0.183911774245864 THEN ((V_RND2-0.17385663314953)*(1/100)/0.0100551410963347)+0.59
WHEN V_RND2 <= 0.194291274732403 THEN ((V_RND2-0.183911774245864)*(1/100)/0.0103795004865391)+0.6
WHEN V_RND2 <= 0.205319493999351 THEN ((V_RND2-0.194291274732403)*(1/100)/0.0110282192669478)+0.61
WHEN V_RND2 <= 0.216672072656503 THEN ((V_RND2-0.205319493999351)*(1/100)/0.0113525786571521)+0.62
WHEN V_RND2 <= 0.22834901070386 THEN ((V_RND2-0.216672072656503)*(1/100)/0.0116769380473565)+0.63
WHEN V_RND2 <= 0.240674667531625 THEN ((V_RND2-0.22834901070386)*(1/100)/0.0123256568277652)+0.64
WHEN V_RND2 <= 0.253324683749594 THEN ((V_RND2-0.240674667531625)*(1/100)/0.0126500162179695)+0.65
WHEN V_RND2 <= 0.266623418747973 THEN ((V_RND2-0.253324683749594)*(1/100)/0.0132987349983782)+0.66
WHEN V_RND2 <= 0.280246513136555 THEN ((V_RND2-0.266623418747973)*(1/100)/0.0136230943885825)+0.67
WHEN V_RND2 <= 0.294518326305546 THEN ((V_RND2-0.280246513136555)*(1/100)/0.0142718131689912)+0.68
WHEN V_RND2 <= 0.309114498864742 THEN ((V_RND2-0.294518326305546)*(1/100)/0.0145961725591956)+0.69
WHEN V_RND2 <= 0.324035030814142 THEN ((V_RND2-0.309114498864742)*(1/100)/0.0149205319493999)+0.7
WHEN V_RND2 <= 0.339604281543951 THEN ((V_RND2-0.324035030814142)*(1/100)/0.0155692507298086)+0.71
WHEN V_RND2 <= 0.355822251054168 THEN ((V_RND2-0.339604281543951)*(1/100)/0.0162179695102173)+0.72
WHEN V_RND2 <= 0.372688939344794 THEN ((V_RND2-0.355822251054168)*(1/100)/0.016866688290626)+0.73
WHEN V_RND2 <= 0.389879987025624 THEN ((V_RND2-0.372688939344794)*(1/100)/0.0171910476808304)+0.74
WHEN V_RND2 <= 0.407395394096659 THEN ((V_RND2-0.389879987025624)*(1/100)/0.0175154070710347)+0.75
WHEN V_RND2 <= 0.425559519948102 THEN ((V_RND2-0.407395394096659)*(1/100)/0.0181641258514434)+0.76
WHEN V_RND2 <= 0.444372364579955 THEN ((V_RND2-0.425559519948102)*(1/100)/0.0188128446318521)+0.77
WHEN V_RND2 <= 0.463833927992215 THEN ((V_RND2-0.444372364579955)*(1/100)/0.0194615634122608)+0.78
WHEN V_RND2 <= 0.48361985079468 THEN ((V_RND2-0.463833927992215)*(1/100)/0.0197859228024651)+0.79
WHEN V_RND2 <= 0.50373013298735 THEN ((V_RND2-0.48361985079468)*(1/100)/0.0201102821926695)+0.8
WHEN V_RND2 <= 0.524489133960428 THEN ((V_RND2-0.50373013298735)*(1/100)/0.0207590009730782)+0.81
WHEN V_RND2 <= 0.545896853713915 THEN ((V_RND2-0.524489133960428)*(1/100)/0.0214077197534869)+0.82
WHEN V_RND2 <= 0.567953292247811 THEN ((V_RND2-0.545896853713915)*(1/100)/0.0220564385338956)+0.83
WHEN V_RND2 <= 0.59033409017191 THEN ((V_RND2-0.567953292247811)*(1/100)/0.0223807979240999)+0.84
WHEN V_RND2 <= 0.613363606876419 THEN ((V_RND2-0.59033409017191)*(1/100)/0.0230295167045086)+0.85
WHEN V_RND2 <= 0.636717482971132 THEN ((V_RND2-0.613363606876419)*(1/100)/0.0233538760947129)+0.86
WHEN V_RND2 <= 0.660720077846254 THEN ((V_RND2-0.636717482971132)*(1/100)/0.0240025948751216)+0.87
WHEN V_RND2 <= 0.685371391501784 THEN ((V_RND2-0.660720077846254)*(1/100)/0.0246513136555303)+0.88
WHEN V_RND2 <= 0.710671423937723 THEN ((V_RND2-0.685371391501784)*(1/100)/0.025300032435939)+0.89
WHEN V_RND2 <= 0.736620175154071 THEN ((V_RND2-0.710671423937723)*(1/100)/0.0259487512163477)+0.9
WHEN V_RND2 <= 0.763217645150827 THEN ((V_RND2-0.736620175154071)*(1/100)/0.0265974699967564)+0.91
WHEN V_RND2 <= 0.790463833927992 THEN ((V_RND2-0.763217645150827)*(1/100)/0.0272461887771651)+0.92
WHEN V_RND2 <= 0.818358741485566 THEN ((V_RND2-0.790463833927992)*(1/100)/0.0278949075575738)+0.93
WHEN V_RND2 <= 0.846902367823549 THEN ((V_RND2-0.818358741485566)*(1/100)/0.0285436263379825)+0.94
WHEN V_RND2 <= 0.87609471294194 THEN ((V_RND2-0.846902367823549)*(1/100)/0.0291923451183912)+0.95
WHEN V_RND2 <= 0.90593577684074 THEN ((V_RND2-0.87609471294194)*(1/100)/0.0298410638987999)+0.96
WHEN V_RND2 <= 0.936425559519948 THEN ((V_RND2-0.90593577684074)*(1/100)/0.0304897826792086)+0.97
WHEN V_RND2 <= 0.967564060979565 THEN ((V_RND2-0.936425559519948)*(1/100)/0.0311385014596173)+0.98
WHEN V_RND2 <= 1 THEN ((V_RND2-0.967564060979565)*(1/100)/0.0324359390204346)+0.99 ELSE V_RND2 END
WHEN P_TYPE = 8 THEN /* 감소 */
CASE WHEN V_RND2 <= 0.0324359390204346 THEN ((V_RND2-0)*(1/100)/0.0324359390204346)+0
WHEN V_RND2 <= 0.0635744404800519 THEN ((V_RND2-0.0324359390204346)*(1/100)/0.0311385014596173)+0.01
WHEN V_RND2 <= 0.0940642231592605 THEN ((V_RND2-0.0635744404800519)*(1/100)/0.0304897826792086)+0.02
WHEN V_RND2 <= 0.12390528705806 THEN ((V_RND2-0.0940642231592605)*(1/100)/0.0298410638987999)+0.03
WHEN V_RND2 <= 0.153097632176452 THEN ((V_RND2-0.12390528705806)*(1/100)/0.0291923451183912)+0.04
WHEN V_RND2 <= 0.181641258514434 THEN ((V_RND2-0.153097632176452)*(1/100)/0.0285436263379825)+0.05
WHEN V_RND2 <= 0.209536166072008 THEN ((V_RND2-0.181641258514434)*(1/100)/0.0278949075575738)+0.06
WHEN V_RND2 <= 0.236782354849173 THEN ((V_RND2-0.209536166072008)*(1/100)/0.0272461887771651)+0.07
WHEN V_RND2 <= 0.263379824845929 THEN ((V_RND2-0.236782354849173)*(1/100)/0.0265974699967564)+0.08
WHEN V_RND2 <= 0.289328576062277 THEN ((V_RND2-0.263379824845929)*(1/100)/0.0259487512163477)+0.09
WHEN V_RND2 <= 0.314628608498216 THEN ((V_RND2-0.289328576062277)*(1/100)/0.025300032435939)+0.1
WHEN V_RND2 <= 0.339279922153746 THEN ((V_RND2-0.314628608498216)*(1/100)/0.0246513136555303)+0.11
WHEN V_RND2 <= 0.363282517028868 THEN ((V_RND2-0.339279922153746)*(1/100)/0.0240025948751216)+0.12
WHEN V_RND2 <= 0.386636393123581 THEN ((V_RND2-0.363282517028868)*(1/100)/0.0233538760947129)+0.13
WHEN V_RND2 <= 0.409665909828089 THEN ((V_RND2-0.386636393123581)*(1/100)/0.0230295167045086)+0.14
WHEN V_RND2 <= 0.432046707752189 THEN ((V_RND2-0.409665909828089)*(1/100)/0.0223807979240999)+0.15
WHEN V_RND2 <= 0.454103146286085 THEN ((V_RND2-0.432046707752189)*(1/100)/0.0220564385338956)+0.16
WHEN V_RND2 <= 0.475510866039572 THEN ((V_RND2-0.454103146286085)*(1/100)/0.0214077197534869)+0.17
WHEN V_RND2 <= 0.49626986701265 THEN ((V_RND2-0.475510866039572)*(1/100)/0.0207590009730782)+0.18
WHEN V_RND2 <= 0.516380149205319 THEN ((V_RND2-0.49626986701265)*(1/100)/0.0201102821926695)+0.19
WHEN V_RND2 <= 0.536166072007785 THEN ((V_RND2-0.516380149205319)*(1/100)/0.0197859228024651)+0.2
WHEN V_RND2 <= 0.555627635420045 THEN ((V_RND2-0.536166072007785)*(1/100)/0.0194615634122608)+0.21
WHEN V_RND2 <= 0.574440480051898 THEN ((V_RND2-0.555627635420045)*(1/100)/0.0188128446318521)+0.22
WHEN V_RND2 <= 0.592604605903341 THEN ((V_RND2-0.574440480051898)*(1/100)/0.0181641258514434)+0.23
WHEN V_RND2 <= 0.610120012974376 THEN ((V_RND2-0.592604605903341)*(1/100)/0.0175154070710347)+0.24
WHEN V_RND2 <= 0.627311060655206 THEN ((V_RND2-0.610120012974376)*(1/100)/0.0171910476808304)+0.25
WHEN V_RND2 <= 0.644177748945832 THEN ((V_RND2-0.627311060655206)*(1/100)/0.016866688290626)+0.26
WHEN V_RND2 <= 0.660395718456049 THEN ((V_RND2-0.644177748945832)*(1/100)/0.0162179695102173)+0.27
WHEN V_RND2 <= 0.675964969185858 THEN ((V_RND2-0.660395718456049)*(1/100)/0.0155692507298086)+0.28
WHEN V_RND2 <= 0.690885501135258 THEN ((V_RND2-0.675964969185858)*(1/100)/0.0149205319493999)+0.29
WHEN V_RND2 <= 0.705481673694453 THEN ((V_RND2-0.690885501135258)*(1/100)/0.0145961725591956)+0.3
WHEN V_RND2 <= 0.719753486863445 THEN ((V_RND2-0.705481673694453)*(1/100)/0.0142718131689912)+0.31
WHEN V_RND2 <= 0.733376581252027 THEN ((V_RND2-0.719753486863445)*(1/100)/0.0136230943885825)+0.32
WHEN V_RND2 <= 0.746675316250406 THEN ((V_RND2-0.733376581252027)*(1/100)/0.0132987349983782)+0.33
WHEN V_RND2 <= 0.759325332468375 THEN ((V_RND2-0.746675316250406)*(1/100)/0.0126500162179695)+0.34
WHEN V_RND2 <= 0.77165098929614 THEN ((V_RND2-0.759325332468375)*(1/100)/0.0123256568277652)+0.35
WHEN V_RND2 <= 0.783327927343497 THEN ((V_RND2-0.77165098929614)*(1/100)/0.0116769380473565)+0.36
WHEN V_RND2 <= 0.794680506000649 THEN ((V_RND2-0.783327927343497)*(1/100)/0.0113525786571521)+0.37
WHEN V_RND2 <= 0.805708725267597 THEN ((V_RND2-0.794680506000649)*(1/100)/0.0110282192669478)+0.38
WHEN V_RND2 <= 0.816088225754136 THEN ((V_RND2-0.805708725267597)*(1/100)/0.0103795004865391)+0.39
WHEN V_RND2 <= 0.82614336685047 THEN ((V_RND2-0.816088225754136)*(1/100)/0.0100551410963347)+0.4
WHEN V_RND2 <= 0.835874148556601 THEN ((V_RND2-0.82614336685047)*(1/100)/0.00973078170613039)+0.41
WHEN V_RND2 <= 0.844956211482322 THEN ((V_RND2-0.835874148556601)*(1/100)/0.0090820629257217)+0.42
WHEN V_RND2 <= 0.85371391501784 THEN ((V_RND2-0.844956211482322)*(1/100)/0.00875770353551735)+0.43
WHEN V_RND2 <= 0.862147259163153 THEN ((V_RND2-0.85371391501784)*(1/100)/0.00843334414531301)+0.44
WHEN V_RND2 <= 0.870256243918262 THEN ((V_RND2-0.862147259163153)*(1/100)/0.00810898475510866)+0.45
WHEN V_RND2 <= 0.878040869283166 THEN ((V_RND2-0.870256243918262)*(1/100)/0.00778462536490431)+0.46
WHEN V_RND2 <= 0.885501135257866 THEN ((V_RND2-0.878040869283166)*(1/100)/0.00746026597469997)+0.47
WHEN V_RND2 <= 0.892637041842361 THEN ((V_RND2-0.885501135257866)*(1/100)/0.00713590658449562)+0.48
WHEN V_RND2 <= 0.899448589036653 THEN ((V_RND2-0.892637041842361)*(1/100)/0.00681154719429127)+0.49
WHEN V_RND2 <= 0.90593577684074 THEN ((V_RND2-0.899448589036653)*(1/100)/0.00648718780408693)+0.5
WHEN V_RND2 <= 0.912098605254622 THEN ((V_RND2-0.90593577684074)*(1/100)/0.00616282841388258)+0.51
WHEN V_RND2 <= 0.9179370742783 THEN ((V_RND2-0.912098605254622)*(1/100)/0.00583846902367824)+0.52
WHEN V_RND2 <= 0.923451183911774 THEN ((V_RND2-0.9179370742783)*(1/100)/0.00551410963347389)+0.53
WHEN V_RND2 <= 0.928640934155044 THEN ((V_RND2-0.923451183911774)*(1/100)/0.00518975024326954)+0.54
WHEN V_RND2 <= 0.933506325008109 THEN ((V_RND2-0.928640934155044)*(1/100)/0.0048653908530652)+0.55
WHEN V_RND2 <= 0.93804735647097 THEN ((V_RND2-0.933506325008109)*(1/100)/0.00454103146286085)+0.56
WHEN V_RND2 <= 0.942588387933831 THEN ((V_RND2-0.93804735647097)*(1/100)/0.00454103146286085)+0.57
WHEN V_RND2 <= 0.946805060006487 THEN ((V_RND2-0.942588387933831)*(1/100)/0.0042166720726565)+0.58
WHEN V_RND2 <= 0.950697372688939 THEN ((V_RND2-0.946805060006487)*(1/100)/0.00389231268245216)+0.59
WHEN V_RND2 <= 0.954265325981187 THEN ((V_RND2-0.950697372688939)*(1/100)/0.00356795329224781)+0.6
WHEN V_RND2 <= 0.957508919883231 THEN ((V_RND2-0.954265325981187)*(1/100)/0.00324359390204346)+0.61
WHEN V_RND2 <= 0.960752513785274 THEN ((V_RND2-0.957508919883231)*(1/100)/0.00324359390204346)+0.62
WHEN V_RND2 <= 0.963671748297113 THEN ((V_RND2-0.960752513785274)*(1/100)/0.00291923451183912)+0.63
WHEN V_RND2 <= 0.966590982808952 THEN ((V_RND2-0.963671748297113)*(1/100)/0.00291923451183912)+0.64
WHEN V_RND2 <= 0.969185857930587 THEN ((V_RND2-0.966590982808952)*(1/100)/0.00259487512163477)+0.65
WHEN V_RND2 <= 0.971780733052222 THEN ((V_RND2-0.969185857930587)*(1/100)/0.00259487512163477)+0.66
WHEN V_RND2 <= 0.974051248783652 THEN ((V_RND2-0.971780733052222)*(1/100)/0.00227051573143042)+0.67
WHEN V_RND2 <= 0.976321764515083 THEN ((V_RND2-0.974051248783652)*(1/100)/0.00227051573143042)+0.68
WHEN V_RND2 <= 0.978267920856309 THEN ((V_RND2-0.976321764515083)*(1/100)/0.00194615634122608)+0.69
WHEN V_RND2 <= 0.980214077197535 THEN ((V_RND2-0.978267920856309)*(1/100)/0.00194615634122608)+0.7
WHEN V_RND2 <= 0.981835874148557 THEN ((V_RND2-0.980214077197535)*(1/100)/0.00162179695102173)+0.71
WHEN V_RND2 <= 0.983457671099578 THEN ((V_RND2-0.981835874148557)*(1/100)/0.00162179695102173)+0.72
WHEN V_RND2 <= 0.9850794680506 THEN ((V_RND2-0.983457671099578)*(1/100)/0.00162179695102173)+0.73
WHEN V_RND2 <= 0.986376905611417 THEN ((V_RND2-0.9850794680506)*(1/100)/0.00129743756081739)+0.74
WHEN V_RND2 <= 0.987674343172235 THEN ((V_RND2-0.986376905611417)*(1/100)/0.00129743756081739)+0.75
WHEN V_RND2 <= 0.988971780733052 THEN ((V_RND2-0.987674343172235)*(1/100)/0.00129743756081739)+0.76
WHEN V_RND2 <= 0.989944858903665 THEN ((V_RND2-0.988971780733052)*(1/100)/0.000973078170613039)+0.77
WHEN V_RND2 <= 0.990917937074278 THEN ((V_RND2-0.989944858903665)*(1/100)/0.000973078170613039)+0.78
WHEN V_RND2 <= 0.991891015244891 THEN ((V_RND2-0.990917937074278)*(1/100)/0.000973078170613039)+0.79
WHEN V_RND2 <= 0.9925397340253 THEN ((V_RND2-0.991891015244891)*(1/100)/0.000648718780408693)+0.8
WHEN V_RND2 <= 0.993188452805708 THEN ((V_RND2-0.9925397340253)*(1/100)/0.000648718780408693)+0.81
WHEN V_RND2 <= 0.993837171586117 THEN ((V_RND2-0.993188452805708)*(1/100)/0.000648718780408693)+0.82
WHEN V_RND2 <= 0.994485890366526 THEN ((V_RND2-0.993837171586117)*(1/100)/0.000648718780408693)+0.83
WHEN V_RND2 <= 0.995134609146935 THEN ((V_RND2-0.994485890366526)*(1/100)/0.000648718780408693)+0.84
WHEN V_RND2 <= 0.995458968537139 THEN ((V_RND2-0.995134609146935)*(1/100)/0.000324359390204346)+0.85
WHEN V_RND2 <= 0.995783327927343 THEN ((V_RND2-0.995458968537139)*(1/100)/0.000324359390204346)+0.86
WHEN V_RND2 <= 0.996107687317548 THEN ((V_RND2-0.995783327927343)*(1/100)/0.000324359390204346)+0.87
WHEN V_RND2 <= 0.996432046707752 THEN ((V_RND2-0.996107687317548)*(1/100)/0.000324359390204346)+0.88
WHEN V_RND2 <= 0.996756406097956 THEN ((V_RND2-0.996432046707752)*(1/100)/0.000324359390204346)+0.89
WHEN V_RND2 <= 0.997080765488161 THEN ((V_RND2-0.996756406097956)*(1/100)/0.000324359390204346)+0.9
WHEN V_RND2 <= 0.997405124878365 THEN ((V_RND2-0.997080765488161)*(1/100)/0.000324359390204346)+0.91
WHEN V_RND2 <= 0.99772948426857 THEN ((V_RND2-0.997405124878365)*(1/100)/0.000324359390204346)+0.92
WHEN V_RND2 <= 0.998053843658774 THEN ((V_RND2-0.99772948426857)*(1/100)/0.000324359390204346)+0.93
WHEN V_RND2 <= 0.998378203048978 THEN ((V_RND2-0.998053843658774)*(1/100)/0.000324359390204346)+0.94
WHEN V_RND2 <= 0.998702562439183 THEN ((V_RND2-0.998378203048978)*(1/100)/0.000324359390204346)+0.95
WHEN V_RND2 <= 0.999026921829387 THEN ((V_RND2-0.998702562439183)*(1/100)/0.000324359390204346)+0.96
WHEN V_RND2 <= 0.999351281219591 THEN ((V_RND2-0.999026921829387)*(1/100)/0.000324359390204346)+0.97
WHEN V_RND2 <= 0.999675640609796 THEN ((V_RND2-0.999351281219591)*(1/100)/0.000324359390204346)+0.98
WHEN V_RND2 <= 1 THEN ((V_RND2-0.999675640609796)*(1/100)/0.000324359390204346)+0.99 ELSE V_RND2 END
ELSE V_RND2
END;
V_RTN_VAL := TRUNC( (P_END-P_BGN+1) * V_RND2 + P_BGN, P_SCL);
RETURN (V_RTN_VAL);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('GETTEMPNUM 에러번호 : ' || SQLCODE);
DBMS_OUTPUT.PUT_LINE('GETTEMPNUM 에러내용 : ' || SQLERRM);
RETURN NULL;
END;
/****************************** FUNCTION 생성 후 테스트하기 ************************************/
/****************************** FUNCTION 생성 후 테스트하기 ************************************/
WITH V1 AS
(
SELECT 1 NO FROM DUAL UNION ALL
SELECT 1 NO FROM DUAL UNION ALL
SELECT 1 NO FROM DUAL UNION ALL
SELECT 1 NO FROM DUAL UNION ALL
SELECT 1 NO FROM DUAL UNION ALL
SELECT 1 NO FROM DUAL UNION ALL
SELECT 1 NO FROM DUAL UNION ALL
SELECT 1 NO FROM DUAL UNION ALL
SELECT 1 NO FROM DUAL UNION ALL
SELECT 1 NO FROM DUAL
)
SELECT NO
, COUNT(*) AS CNT
FROM (
SELECT GETTEMPNUM(5,1,10,0,3) AS NO
FROM V1,V1,V1,V1,V1
)
GROUP BY NO
ORDER BY 1
;
'전산Tip > Oracle' 카테고리의 다른 글
| [ORACLE] 랜덤 분포 (1) | 2011.11.04 |
|---|---|
| [ORACLE] 테이블스페이스 DATAFILE 확장하기 (1) | 2011.09.28 |
| [ORACLE] 사용자생성 및 select 권한 추가 (0) | 2011.09.06 |