Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: add sysdate to column name
On Sep 27, 11:22 am, alex <sql_..._at_yahoo.com> wrote:
> On Sep 27, 12:12 pm, vitalis..._at_gmail.com (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
Possibly this is what you desire:
SQL> column sysdate new_value sdate noprint SQL> SQL> select sysdate from dual;
SQL>
SQL> create table mytest(testcol varchar2(20));
Table created.
SQL>
SQL> insert into mytest
2 values ('This is a test.');
1 row created.
SQL>
SQL> select testcol as "&sdate"
2 from mytest;
old 1: select testcol as "&sdate"
new 1: select testcol as "27-SEP-07"
27-SEP-07
SQL>
SQL> drop table mytest;
Table dropped.
SQL> SQL> clear columns SQL>
David Fitzjarrell Received on Thu Sep 27 2007 - 11:52:40 CDT
![]() |
![]() |