[getExportList]
select *
from :table_id
where 1 = 1
:where_str
order by :order_by

[getExportFieldList]
select han_name, koumoku3, koumoku4, koumoku5, koumoku6, koumoku7, koumoku8, koumoku9, koumoku10, koumoku11, koumoku12
from m_hanyo
where mst_kbn = 'AT'
and han_cd like ':exp_kind-%'
order by han_cd

[selectNameList]
select
  w.han_name as han_cd
, w.han_name
, w.han_name as koumoku3
, w.han_name as sort_key
from (
	SELECT distinct han_name
	FROM m_hanyo
	WHERE mst_kbn = '06'
	AND trim(han_name) != ''
) w
order by sort_key, han_cd




