将数字当成字符串来处理,就是用双引号加起来就可以了。 看下面的测试: SQL> select sysdate "111" from dual;111 ----------- 2005-3-2 18SQL> select sysdate as "111" from dual;111 ----------- 2005-3-2 18SQL> select sysdate as 111 from dual;select sysdate as 111 from dualORA-00923: 未找到预期 FROM 关键字SQL> select sysdate 111 from dual;select sysdate 111 from dualORA-00923: 未找到预期 FROM 关键字但下面这个可以:SQL> select sysdate v_date from dual;V_DATE ----------- 2005-3-2 18所以怎么选择得看自己了。
看下面的测试:
SQL> select sysdate "111" from dual;111
-----------
2005-3-2 18SQL> select sysdate as "111" from dual;111
-----------
2005-3-2 18SQL> select sysdate as 111 from dual;select sysdate as 111 from dualORA-00923: 未找到预期 FROM 关键字SQL> select sysdate 111 from dual;select sysdate 111 from dualORA-00923: 未找到预期 FROM 关键字但下面这个可以:SQL> select sysdate v_date from dual;V_DATE
-----------
2005-3-2 18所以怎么选择得看自己了。