oracle中小写转换成大写的方法

oracle中小写转换成大写的方法

 

Sql代码  

select SPEC_CODE,  

    item_number,  

    self_item_code,  

    MASTER_FLG ,  

    update_date  

from if_kikaku.item_m  

where user_cd = '868668'  

and xfimconv(self_item_code) = xfimconv('a999')  

order by update_date desc;  

 

 执行结果：

Sql代码  

    SPEC_CODE   ITEM_NUMBER SELF_ITEM_CODE  MASTER_FLG  UPDATE_DATE  

1   G0001939-33028C10-202E2EXX555   G0001939-33028C10-202E2EXX555   a999    0   2013/03/01  

2   G0001939-33028C10-202E2EXX444   G0001939-33028C10-202E2EXX444   A999    0   2013/02/04  

3   G0001939-33028C10-202E0EXX333   G0001939-33028C10-202E0EXX333   A999    0   2013/02/03  

4   G0001939-33028C10-202E0EXX222   G0001939-33028C10-202E1EXX222   A999    0   2013/02/02  

5   G0001939-33028C10-202E2EXX111   G0001939-33028C10-202E3EXX111-004017    A999    0   2013/02/01  

 

http://www.htsjk.com/oracle/21894.html www.htsjk.Com true http://www.htsjk.com/oracle/21894.html NewsArticle oracle中小写转换成大写的方法 oracle中小写转换成大写的方法 Sql代码 select SPEC_CODE, item_number, self_item_code, MASTER_FLG , update_date from if_kikaku.item_m where user_cd = 868668 and xfimconv(self_item_code) = xf...