SELECT * FROM ( 
 SELECT AA.*, ROWNUM R, BB.CNT FROM (
  SELECT DISTINCT A.BRCH_CD, 
   CASE WHEN A.PSTN_NM IS NOT NULL AND LENGTH (TRIM (A.PSTN_NM)) > 0 THEN A.PSTN_NM 
   ELSE A.BRCH_NM END PSTN_NM, 
   A.BRCH_ADDR, A.CEN_TYPE, A.BRCH_REPR_TEL_NO AS TEL_NO, A.BRCH_FAX_NO AS FAX_NO, B.COORD_X 
   , B.COORD_Y, TRAFFIC, A.PSTN_TYPE 
  FROM TBZZTD10 A, 
   ( 
    SELECT * FROM ( 
     SELECT DISTINCT D.SI_GUN_GU_NM GU_NM, A.BRCH_CD, B.PSTN_CD 
     , B.PSTN_NM, B.COORD_X, B.COORD_Y, B.TRAFFIC 
     , A.H_DONG_NM H_DONG, A.B_DONG_NM B_DONG 
    FROM TBZZTD09 A, TBWBTZ06 B, TBZZTD03 D 
    WHERE A.BRCH_CD > ' ' AND B.PSTN_CD LIKE A.BRCH_CD || '%' 
     AND A.SI_DO_CD = D.SI_DO_CD 
     AND A.SI_GUN_GU_CD = D.SI_GUN_GU_CD 
   ) JISA 
   WHERE  GU_NM LIKE '%강남%') B WHERE 
    A.BRCH_CD = B.BRCH_CD AND A.BRCH_ADPT_YN = 'Y' AND B.COORD_X IS NOT NULL 
    AND A.BRCH_CD || A.PSTN_TYPE || '00' = B.PSTN_CD  
  ORDER BY A.BRCH_CD, A.PSTN_TYPE 
 ) AA,
            (SELECT DISTINCT COUNT(T2.BRCH_CD) AS CNT, T2.BRCH_CD FROM (
  SELECT DISTINCT A.BRCH_CD, 
   CASE WHEN A.PSTN_NM IS NOT NULL AND LENGTH (TRIM (A.PSTN_NM)) > 0 THEN A.PSTN_NM 
   ELSE A.BRCH_NM END PSTN_NM, 
   A.BRCH_ADDR, A.CEN_TYPE, A.BRCH_REPR_TEL_NO AS TEL_NO, A.BRCH_FAX_NO AS FAX_NO, B.COORD_X 
   , B.COORD_Y, TRAFFIC, A.PSTN_TYPE 
  FROM TBZZTD10 A, 
   ( 
    SELECT * FROM ( 
     SELECT DISTINCT D.SI_GUN_GU_NM GU_NM, A.BRCH_CD, B.PSTN_CD 
     , B.PSTN_NM, B.COORD_X, B.COORD_Y, B.TRAFFIC 
     , A.H_DONG_NM H_DONG, A.B_DONG_NM B_DONG 
    FROM TBZZTD09 A, TBWBTZ06 B, TBZZTD03 D 
    WHERE A.BRCH_CD > ' ' AND B.PSTN_CD LIKE A.BRCH_CD || '%' 
     AND A.SI_DO_CD = D.SI_DO_CD 
     AND A.SI_GUN_GU_CD = D.SI_GUN_GU_CD 
   ) JISA 
   WHERE  GU_NM LIKE '%강남%') B WHERE 
    A.BRCH_CD = B.BRCH_CD AND A.BRCH_ADPT_YN = 'Y' AND B.COORD_X IS NOT NULL 
    AND A.BRCH_CD || A.PSTN_TYPE || '00' = B.PSTN_CD  
  ORDER BY A.BRCH_CD, A.PSTN_TYPE
            )T1, TBWBTZ09 T2
            WHERE T1.BRCH_CD = T2.BRCH_CD
                  AND T1.PSTN_TYPE = T2.PSTN_TYPE
                  GROUP BY T2.BRCH_CD
 ) BB
 WHERE  ROWNUM <= 10
        AND AA.BRCH_CD = BB.BRCH_CD
) WHERE  R BETWEEN 1 AND 10

 ====>

이렇게 쿼리를 짰는데....

토드에서는 돌리니깐 정상적으로 나오는데..... 자바소스에 박아 넣으니 [테이블 또는 뷰가 없습니다....]라는 메세지가 나오네요....

기존에 잘 돌던 쿼리를 조금 수정한건데...

테이블 시노님 문젠 아닌거 같구요.....

또 무슨일런지요.....

쫌 알려주세요~~~~