DB/Oracle

CREATE TABLE T AS ( SELECT 123456789012345 AMT FROM DUAL UNION ALL SELECT 29000 FROM DUAL UNION ALL SELECT 309840 FROM DUAL ) ; SELECT AMT , TRANSLATE ( SUBSTR(V, 1,1)||DECODE(SUBSTR(V, 1,1),0,'','천') || SUBSTR(V, 2,1)||DECODE(SUBSTR(V, 2,1),0,'','백') || SUBSTR(V, 3,1)||DECODE(SUBSTR(V, 3,1),0,'','십') || SUBSTR(V, 4,1)||DECODE(SUBSTR(V, 1,4),0,'','조') || SUBSTR(V, 5,1)||DECODE(SUBSTR(V, 5,1),0,'..

DELETE FROM EMP A WHERE EXISTS ( SELECT 1 FROM DEPT B WHERE A.DEPTNO = B.DEPTNO AND B.DEPTNO = '20' ); DELETE FROM EMP A WHERE A.DEPTNO = ( SELECT B.DEPTNO FROM DEPT B WHERE A.DEPTNO = B.DEPTNO AND B.DEPTNO = '20' ); DELETE FROM EMP A WHERE (A.DEPTNO, A.ENAME) = ( SELECT B.DEPTNO, B.NAME FROM DEPT B WHERE B.DEPTNO = '20' );

SELECT TO_CHAR(TO_DATE('20150201', 'YYYYMMDD') + NUM - 1, 'YYYY-MM-DD') AS YYYYMMDD FROM ( SELECT ROWNUM AS NUM FROM DUAL CONNECT BY LEVEL

SELECT TO_NUMBER(TO_CHAR(MIN(SUN), 'DD')) "일" , TO_NUMBER(TO_CHAR(MIN(MON), 'DD')) "월" , TO_NUMBER(TO_CHAR(MIN(TUE), 'DD')) "화" , TO_NUMBER(TO_CHAR(MIN(WED), 'DD')) "수" , TO_NUMBER(TO_CHAR(MIN(THU), 'DD')) "목" , TO_NUMBER(TO_CHAR(MIN(FRI), 'DD')) "금" , TO_NUMBER(TO_CHAR(MIN(SAT), 'DD')) "토" FROM ( SELECT TRUNC(MONTH, 'D') GUBN , DECODE(WEEK, 1, MONTH) SUN , DECODE(WEEK, 2, MONTH) MON , DECODE(WE..

테이블생성 CREATE TABLE BOM ( ITEM_ID INTEGER NOT NULL, PARENT_ID INTEGER, ITEM_NAME VARCHAR2(20) NOT NULL, ITEM_QTY INTEGER, PRIMARY KEY (ITEM_ID)); 데이터 저장 INSERT INTO BOM VALUES (1001, NULL, '컴퓨터', 1); INSERT INTO BOM VALUES (1002, 1001, '본체', 1); INSERT INTO BOM VALUES (1003, 1001, '모니터', 1); INSERT INTO BOM VALUES (1004, 1001, '프린터', 1); INSERT INTO BOM VALUES (1005, 1002, 'MOTHER BOARD', 1); INS..