오라클 함수정리 1탄 SELECT EMPLOYEE_ID , FIRST_NAME , LAST_NAME , EMAIL , JOB_ID FROM EMPLOYEES WHERE email = 'SKING';-- 주석설정->Ctrl + - // 주석해제->Ctrl+Shift + --- 테이블 NAME, --줄 맞춤 SELECT라인 FIRST라인 ,세미콜론주의 ;SELECT COUNT(JOB_ID) FROM EMPLOYEES ;SELECTDISTINCT JOB_ID--중복행의 제거 DISTINCT + HOW FIND? FROM EMPLOYEES; SELECT JOB_ID , FIRST_NAME , LAST_NAME , SALARYFROM EMPLOYEES WHERE SALARY = '01-JAN-03' AND HIRE_DATE = 100.. 더보기 이전 1 ··· 45 46 47 48 49 50 51 ··· 172 다음