Re: add sysdate to column name
- From: alex <sql_aid@xxxxxxxxx>
- Date: Thu, 27 Sep 2007 09:22:30 -0700
On Sep 27, 12:12 pm, vitalis...@xxxxxxxxx (Jerome Vitalis) wrote:
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/
"sysdate" is returning the name "SYSDATE"
i'm looking for the system's date to become the name of the column
.
- Follow-Ups:
- Re: add sysdate to column name
- From: fitzjarrell@xxxxxxx
- Re: add sysdate to column name
- References:
- add sysdate to column name
- From: alex
- Re: add sysdate to column name
- From: Jerome Vitalis
- add sysdate to column name
- Prev by Date: Re: add sysdate to column name
- Next by Date: Re: RMAN Log Analyzer
- Previous by thread: Re: add sysdate to column name
- Next by thread: Re: add sysdate to column name
- Index(es):
Relevant Pages
|
