select
CASE WHEN m_i_age_year = '' THEN seq/100
WHEN m_i_age_year <> '' THEN to_number(m_i_age_year, '0000000000')
END AS m_i_age_year
from tbl_estate_article;
CASE WHEN m_i_age_year = '' THEN seq/100
WHEN m_i_age_year <> '' THEN to_number(m_i_age_year, '0000000000')
END AS m_i_age_year
from tbl_estate_article;
0 件のコメント:
コメントを投稿