Re: Rename Columns in MS Query

From: Frank <fbortel_at_nescape.net>
Date: Fri, 14 Nov 2003 12:30:00 +0100
Message-ID: <bp2dsh$ngm$1_at_news3.tilbu1.nb.home.nl>

Lasse wrote:

> Hi!
>
> I have problem to rename columns in MS Query.
>
> I use MS Query (Ver. 2000) to get data from an Oracle Server (Ver.
> 8.1.7...).
>
> In Oracle the script is: Select columnname as "name"...
> and in MS Query I guess it's: Select Columnname as ‘name'...
> but it does work.
>
> I have tried to double click in the Columnname and set a name in
> Column heading: , but I get an error message when I run the query.
> (ORA-00923: From keyword not found where expected) but the SQL code
> is: Select Columnname AS 'name'....
>
> Please, can somebody help me!
>
> Regards Lasse

Works without the quotes:
SQL> select sysdate as time from dual;

TIME

---

14-NOV-03 Or: select sysdate "time" from dual;
time

---

14-NOV-03
Notice the different case. Anything in double quotes will be taken literally by Oracle

-- 
Regards, Frank van Bortel

Received on Fri Nov 14 2003 - 12:30:00 CET