IT/ORACLE6 ORACLE 가장 긴 / 짧은 문자열 도출 *가장 긴 문자열 SELECT * FROM (SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC ) WHERE ROWNUM = 1; *가장 짧은 문자열 SELECT * FROM (SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC ) WHERE ROWNUM = 1; 2022. 10. 31. ORACLE 짝수 / 홀수 구분 방법 -- 홀수 SELECT A.USER_ID ,A.USER_NAME FROM TEST where MOD(A.USER_ID, 2) = 1 -- 짝수 SELECT A.USER_ID ,A.USER_NAME FROM TEST where MOD(A.USER_ID, 2) = 0 2022. 10. 31. 이전 1 2 다음