오라클 .. java의 스플릿 기능 split과 비슷한거

SELECT  wr_no, wr_title, wr_writer, wr_passwd,wr_viewCnt,wr_content,to_char(WR_writeDate,'yyyy-MM-dd') wr_date ,
        WR_REPLYCNT, WR_GNO, WR_PARENT, WR_DEPTH,  WR_GORDER, WR_EMAIL, 
        WR_HOMEPAGE ,(SELECT COUNT(*)  FRoM WR_Notice_NOTICE) wrTotal ,
     subStr(TO_CHAR((sysdate-wr_writedate)*24),0,INSTR(TO_CHAR((sysdate-wr_writedate)*24),'.')-1)  NEWdate FROM WR_NOTICE_NOTICE
         ORDER BY wr_writedate DESC;
        

 

 

INSTR(TO_CHAR((sysdate-wr_writedate)*24),'.')-1

 

문자로만 가능 숫자 불가능 .. 문자안에 특정 문자의 위치를 리턴한다.