카테고리 목록( connect_by_path() )

SELECT SYS_CONNECT_BY_PATH(KMS020_MENU_NM, '>') AS PATH

  FROM KMS020TL

 start with KMS020_MENU_UPCD = '0000'

connect by prior KMS020_MENU_CD = KMS020_MENU_UPCD

 

대 > 중 > 소