-

Oracle 원격 서버를 접속하기 위해서는 SQL Developer라는 프로그램이 필요합니다 프로그램을 다운로드하기 위해 아래 링크를 통해 SQL Developer를 다운로드하시면 됩니다 https://www.oracle.com/kr/database/sqldeveloper/technologies/download/ Oracle SQL Developer Downloads | Oracle 대한민국This archive. will work on a 32 or 64 bit Windows OS. The bit level of the JDK you install will determine if it runs as a 32 or 64 bit application. This download does not include..

WITH DTABLE(NAME, WEEK, GRADE) AS( SELECT '이름1', 1, 'A' FROM DUAL UNION ALL SELECT '이름1', 2, 'A+' FROM DUAL UNION ALL SELECT '이름2', 1, 'A' FROM DUAL UNION ALL SELECT '이름2', 2, 'B' FROM DUAL UNION ALL SELECT '이름3', 1, 'B' FROM DUAL UNION ALL SELECT '이름3', 2, 'A' FROM DUAL) SELECT DISTINCT NAME, (SELECT GRADE FROM DTABLE WHERE NAME = T.NAME AND WEEK = 1) "1주", (SELECT GRADE FROM DTABLE WHERE NAME ..

검색시 Like 연산자를 써서 특수문자를 검색할때 검색이 되지 않는 문제 발생... 결과는 ESCAPE 키워드를 써서 검색 완료 WITH T(D) AS( SELECT 'ADA_AAA' FROM DUAL UNION ALL SELECT 'ADB_AAA' FROM DUAL UNION ALL SELECT 'AD_AAA' FROM DUAL UNION ALL SELECT 'ADC_AAA' FROM DUAL UNION ALL SELECT 'ADD_AAA' FROM DUAL) SELECT * FROM t WHERE D LIKE 'AD/_%' escape '/'

위치를 시각화 해주는 쿼리 WITH T(MENU_NM, SEQ1, SEQ2) AS ( SELECT '상1' , 1, 0 FROM DUAL UNION ALL SELECT '상1중1' , 2, 1 FROM DUAL UNION ALL SELECT '상1중2' , 3, 1 FROM DUAL UNION ALL SELECT '상2중1' , 9, 7 FROM DUAL UNION ALL SELECT '상1중1하1' , 4, 2 FROM DUAL UNION ALL SELECT '상1중1하2' , 5, 2 FROM DUAL UNION ALL SELECT '상1중2하1' , 6, 3 FROM DUAL UNION ALL SELECT '상1중1하1밑1' , 8, 4 FROM DUAL UNION ALL SELECT '상2' , ..

테이블 정렬을 하고 싶을때 사용법 기존 테이블 형식 순서 DNUM DNAME 1 1 TEST1 2 1 TEST2 3 1 TEST3 4 2 TEST4 5 2 TEST5 6 2 TEST6 1번 사용법 WITH T(DNUM, DNAME) AS ( SELECT 1, 'TEST1' FROM DUAL UNION ALL SELECT 1, 'TEST2' FROM DUAL UNION ALL SELECT 1, 'TEST3' FROM DUAL UNION ALL SELECT 2, 'TEST4' FROM DUAL UNION ALL SELECT 2, 'TEST5' FROM DUAL UNION ALL SELECT 2, 'TEST6' FROM DUAL) SELECT MAX(DECODE(DNUM, 1, DNAME)) "1", MAX(..