commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Petite Abeille <petite_abei...@mac.com>
Subject Re: [dbutils]
Date Tue, 21 Dec 2010 21:50:58 GMT

On Dec 21, 2010, at 2:14 PM, Nikhil wrote:

> Query: SELECT USER_ID as user, USER_NAME as name FROM T_USER_MSTR

"user", like half of the English language, is a reserved word in Oracle:

http://download.oracle.com/docs/cd/B10500_01/appdev.920/a42525/apb.htm

If you insist in using it, you must double quote it:


SELECT USER_ID as "user", USER_NAME as name FROM T_USER_MSTR

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org


Mime
View raw message