Oracle 3
col b_year format a10; select substr(hiredate,1,2) b_year from emp select ltrim(rtrim(mail, substr(mail,instr(mail,'.'))), substr(mail,1,instr(mail,'@'))) from t1 ->회사명뽑기 최종변경: select substr(mail,1,instr(mail,'@')-1) ID, //instr은 해당문자를 만날떄까지의 자리수 ltrim(rtrim(mail, substr(mail,instr(mail,'.'))) ,substr(mail,1,instr(mail,'@'))) com1, substr(mail,instr(mail,'.')+1) com2 from t1 컬럼의 간격을 조정하기 위해 col ..
더보기