今天做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_NMFROMT_SM_FUNCTIONST,T_SM_FUNCTIONST1WHERET.FUN_ID=T1.PAR_FUN_IDANDT.FUN_ID='5'ANDT1.FUN_ID<>'5'

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

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

Stringsql="SELECTT.FUN_ID\"pid\",T1.FUN_ID\"id\",T1.FUN_NM\"text\",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='"+funid+"'"+"ANDT1.FUN_ID<>'"+funid+"'";List<?>list=this.queryForList(sql);returnlist;