Re: add sysdate to column name

From: <fitzjarrell_at_cox.net>
Date: Thu, 27 Sep 2007 09:52:40 -0700
Message-ID: <1190911960.844707.286190@y42g2000hsy.googlegroups.com>

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

---

This is a test.

SQL>
SQL> drop table mytest;

Table dropped.

SQL>
SQL> clear columns
SQL>

David Fitzjarrell Received on Thu Sep 27 2007 - 11:52:40 CDT