今天做bootstrap的treeview，要求输入节点ID id，父节点ID pid，文本 text

但是执行的sql别名都是大写，所以找了下orcl的别名如何小写的问题

代码如下：

SELECTT.FUN_ID"pid",T1.FUN_IDid,T1.FUN_NMtext,T1.FUN_ID,T1.FUN_CD,T1.FUN_NM
FROMT_SM_FUNCTIONST,T_SM_FUNCTIONST1
WHERET.FUN_ID=T1.PAR_FUN_ID
ANDT.FUN_ID='5'
ANDT1.FUN_ID<>'5'

别名加上双引号即别名显示为小写

如果是在java中 则用转义的方式，如下

Stringsql="SELECTT.FUN_ID\"pid\",T1.FUN_ID\"id\",T1.FUN_NM\"text\",T1.FUN_NM"
	+"FROMT_SM_FUNCTIONST,T_SM_FUNCTIONST1"
	+"WHERET.FUN_ID=T1.PAR_FUN_ID"
	+"ANDT.FUN_ID='"+funid+"'"
	+"ANDT1.FUN_ID<>'"+funid+"'";
		List<?>list=this.queryForList(sql);
		returnlist;