블로그
- 프로시저에서 배열, 커서 Type 사용 해 보자.. ARRAY_VARCHAR(ICNT) := ''; ARRAY_NUMBER(ICNT) := 0; END LOOP; -- 커서 타입 사용 예 SQLQUERY := 'SELECT DUMMY FROM DUAL'; OPEN P_CURSOR FOR SQLQUERY; LOOP FETCH P_CURSOR INTO DUMMY; EXIT WHEN P_CURSOR%NOTFOUND; DBMS_OUTPUT.PUT_LINE
- NOT IN 과 '' 과 NULL 의 사용법에 따른 차이 SELECT NVL(COL1, 'NULL') FROM ( SELECT '00' COL1 FROM DUAL UNION ALL SELECT '01' COL1 FROM DUAL UNION ALL SELECT '02' COL1 FROM DUAL UNION ALL SELECT '' COL1 FROM DUAL UNION ALL SELECT NULL COL1 FROM DUAL
- 아이패드 10.1 해외리뷰 The BGR team picked up the new and improved Samsung’s Galaxy Tab 10.1 from Google’s I/O conference earlier It’s powered by a dual-core NVIDIA Tegra 2 processor, contains 32GB of storage.......
- OUTER JOIN 비슷한 여러가지 쿼리 SELECT * FROM ( SELECT '가' COL1 FROM DUAL UNION ALL SELECT '나' COL1 FROM DUAL ) A ,( SELECT '가' COL1 FROM DUAL ) B WHERE A.COL1 = B.COL1(+) CO CO -- -- 가 가 나 SELECT * FROM ( SELECT '가' COL1 FROM DUAL UNION
- MONTHS_BETWEEN - 월 단위로 날짜를 연산하는 함수 예) SELECT MONTHS_BETWEEN('20110101' , '20110201') FROM DUAL 결과 : -1 SELECT MONTHS_BETWEEN ('20110301' , '20110201') FROM DUAL 결과 : 1 SELECT MONTHS_BETWEEN('20100101' , '20110331') FROM DUAL 결과
- CEIL 지정한 숫자보다 크거나 같은 정수 중에서 최소값을 출력 - CEIL(n) : n이 정수인 경우 -> n 소수인경우 -> n+1 예) SELECT CEIL(15.6) FROM DUAL; 결과 : 16 SELECT CEIL(15.1) FROM DUAL; 결과 : 16 SELECT CEIL(15) FROM DUAL; 결과 : 15
- 저장형 함수 테스트 v_return_val NUMBER := 0;BEGIN SELECT DECODE(p_val, 1, p_val * 1.5, 2, p_val * 2) INTO v_return_val FROM DUAL; RETURN v_return_val;END XSOFT_TAB_FUNC;그리고.......
- bcdedit 사용 If your running XP and Vista (dual booting), you can use bcdedit from the command line to change the If you are dual booting XP Prof and Vista, you most likely have the annoying "Earlier Version of Windows
- 전월 구하기 SELECT LTRIM(TO_CHAR(TO_NUMBER('02') - 1,'00')) FROM DUAL
- road to perdition "Road to Perdition" is a title with a dual meaning. Tom Hanks, who stars as Michael Sullivan, offers, "The message from Michael the father to Michael the
← 이전
5 페이지