Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: add sysdate to column name

Re: add sysdate to column name

From: <fitzjarrell_at_cox.net>
Date: Wed, 03 Oct 2007 07:00:57 -0700
Message-ID: <1191420057.274283.313800@57g2000hsv.googlegroups.com>


On Sep 27, 5:00 pm, DA Morgan <damor..._at_psoug.org> 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?
>
> > alex
>
> Whether it is possible I will leave for others to help you with.
>
> SELECT keyword
> FROM gv$reserved_words
> WHERE keyword LIKE 'SYSD%';
>
> however might be worth running.
>
> You are heading for a train wreck. Why intentionally walk on the tracks?
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Some are born as natural 'SQL Thrill Seekers'. Think, I guess, of Evel Kneivel as an Oracle DBA or developer ...

David Fitzjarrell Received on Wed Oct 03 2007 - 09:00:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US