Re: add sysdate to column name

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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org