Re: add sysdate to column name

From: Jerome Vitalis <vitalis..._at_gmail.com>
Date: 27 Sep 2007 16:12:33 GMT
Message-ID: <46fbd671$0$19839$426a74cc@news.free.fr>

alex wrote:

> Hello experts,

> i'm attempting to add the sysdate to (not the record) but as the
> column name.

> something like select record as sysdate.

> i'm getting an error, however.

> is this possible?

Yes, with something like this:

select 'foo' "sysdate" from dual;

---

échangez opinions et commentaires dans les forums de discussion. http://www.usenetgratuit.com/ Received on Thu Sep 27 2007 - 11:12:33 CDT