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

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;

 执行结果：

   	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