commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Guy Rouillier <guyr-...@burntmail.com>
Subject Re: [dbutils]
Date Tue, 21 Dec 2010 21:34:59 GMT
On 12/21/2010 12:31 PM, Steve Ash wrote:
> Nikhil,
>
> This is an oracle syntax problem, not a DbUtils problem.  Oracle
> doesn't support "as" to alias names in the projection list.  Try
> SELECT USER_ID user, USER_NAME name FROM T_USER_MSTR

That must be for very old versions of Oracle.  Since at least Oracle 8, 
this works fine:

select sysdate as today from dual

-- 
Guy Rouillier

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


Mime
View raw message