공부하자/IT
2013. 5. 21.
[SQL] 실무에 바로 쓰는 SQL 활용
1일차 --select * FROM TEAM_T; SELECT * FROM PLAYER_T; --SELECT team_name, tel, translate(tel,'0123456789','영일이삼사오육칠팔구') FROM TEAM_T; --SELECT player_name, e_player_name FROM PLAYER_T WHERE e_player_name LIKE '%e%e%e%' AND e_player_name NOT LIKE '%e%e%e%e%'; --SELECT PLAYER_NAME, E_PLAYER_NAME FROM PLAYER_T WHERE INSTR(UPPER(e_player_name),'E',1,3)>0 AND INSTR(UPPER(e_player_name),'E',1,4)=0; /* 13..