Oracle_11.2_Work.sql

select 
  (select clscode from tCatCategory 
    where clscode like '__' )
    as ¶þ¼¶±àÂë
  from tCatCategory 
  where clscode like '_' 
  order by clscode

select clscode as Ëļ¶±àÂë, clsname as Ëļ¶Ãû³Æ
  from tCatCategory 
  where clscode like '____' 
  order by clscode