정미나닷컴

2012년 1월에 팔린 상품의 일별 상품별 판매수량과 판매금액 및 각각의 랭킹을 구하고 일별, 월별 총계 구하기 * 결과값：：： * 쿼리1SELECT CASE WHEN GROUPING(O.ORD_DT)=1 AND GROUPING(I.ITEM_ID)=1 THEN '201201' ELSE O.ORD_DT END ORD_DT, I.ITEM_ID, CASE WHEN GROUPING(O.ORD_DT)=1 AND GROUPING(I.ITEM_ID)=1 THEN '합계' WHEN GROUPING(I.ITEM_ID)=1 THEN '소계' ELSE I.ITEM_NM END ITEM_NM, SUM(O.ORD_ITEM_QTY) QTY, SUM(O.ORD_ITEM_QTY*P.PRICE) PRICE, CASE WHEN GROU..

public String getPaging(int totalCount, int currentPage, int pageSize, int pageGroupSize){ String pageStr = ""; int pageGroupCount = totalCount / (pageSize * pageGroupSize) + (totalCount % (pageSize * pageGroupSize) == 0 ? 0 :1); int numPageGroup = (int)Math.ceil((double)currentPage / pageGroupSize); if (totalCount > 0){ int pageCount = (totalCount / pageSize) + (totalCount % pageSize == 0 ? 0 :..

ASCIISTR BIN_TO_NUM CAST CHARTOROWID COMPOSE CONVERT HEXTORAW NUMTODSINTERVAL NUMTOYMINTERVAL RAWTOHEX RAWTONHEX ROWIDTOCHAR ROWIDTONCHAR TO_CHAR(character) TO_CLOB TO_DSINTERVAL TO_LOB TO_MULTI_BYTE TO_NCHAR(character) TO_NCHAR(datetime) TO_NCHAR(number) TO_NCLOB TO_NUMBER TO_SINGLE_BYTE TO_YMINTERVAL TRANSLATE ... USING UNISTR

private static double getAngle(int x1,int y1, int x2,int y2) { int dx = x2 - x1; int dy = y2 - y1; double rad= Math.atan2(dx, dy); double degree = (rad*180)/Math.PI ; return degree; }