데이터베이스 퀴즈 및 튜닝 문제
저두.. 퀴즈 낼께요..ㅎㅎ
1
2,780
by 박종정 [2008.05.22 18:15:51]
아래 그림고 같이 나올수 있도록 구현해 보세요..^^*
자연수 N을 넣었을때 N개의 만큼 랜덤 그래프 막대기가 생기면 됩니다..^^*
by xo
[2008.05.23 13:08:07]
SELECT
REPLACE(MAX(SYS_CONNECT_BY_PATH(CASE WHEN A.RNVL >= B.NUM THEN '▒ ' ELSE ' -- ' END,'$')),'$','') GRAPH
FROM (
SELECT
ROWNUM SEQ,
ROUND(DBMS_RANDOM.VALUE(0,:RANDOM_VALUE)) RNVL
FROM ALL_OBJECTS
WHERE ROWNUM <= :RANDOM_VALUE
) A,
(SELECT ROWNUM NUM FROM ALL_OBJECTS WHERE ROWNUM <= :RANDOM_VALUE) B
START WITH A.SEQ = 1
CONNECT BY PRIOR A.SEQ = A.SEQ - 1
AND PRIOR B.NUM = B.NUM
GROUP BY B.NUM
ORDER BY B.NUM DESC
REPLACE(MAX(SYS_CONNECT_BY_PATH(CASE WHEN A.RNVL >= B.NUM THEN '▒ ' ELSE ' -- ' END,'$')),'$','') GRAPH
FROM (
SELECT
ROWNUM SEQ,
ROUND(DBMS_RANDOM.VALUE(0,:RANDOM_VALUE)) RNVL
FROM ALL_OBJECTS
WHERE ROWNUM <= :RANDOM_VALUE
) A,
(SELECT ROWNUM NUM FROM ALL_OBJECTS WHERE ROWNUM <= :RANDOM_VALUE) B
START WITH A.SEQ = 1
CONNECT BY PRIOR A.SEQ = A.SEQ - 1
AND PRIOR B.NUM = B.NUM
GROUP BY B.NUM
ORDER BY B.NUM DESC