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: Newbie Oracle SQL question

Re: Newbie Oracle SQL question

From: Andy Hardy <junkmail_at_[127.0.0.1>
Date: Wed, 27 Aug 2003 19:31:40 +0100
Message-ID: <fy$Jl$BMkPT$Ewt6@[127.0.0.1]>


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: 0xA62A4849
Received on Wed Aug 27 2003 - 13:31:40 CDT

Original text of this message

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