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, 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