Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie Oracle SQL question
In message <4f660755.0308271027.533445cd_at_posting.google.com> , Peter J
Marrin <petemarrin54_at_hotmail.com> writes
>I can't get Oracle to handle this type of query:
>SELECT *, 'hello' AS Greeting FROM table
>
select table.*, hello as greeting
from table
-- Andy Hardy. PGP ID: 0xA62A4849Received on Wed Aug 27 2003 - 13:31:40 CDT
![]() |
![]() |