Re: Trying to run a SELECT...INTO SQL Command

[Quoted] Oracle doesn't use as to designate column aliases.

[Quoted] Peter DeSimone <pdesimone_at_sageus.com> wrote in article <6v37lv$peh$1_at_news-1.news.gte.net>...
> When I run this SQL Command through the SQL tool in Oracle, I get the
 error
> below it:
>
> SELECT tsp.TSP_COMPONENTS.ID AS LEVEL0ID, tsp.TSP_COMPONENTS.NAME AS
> LEVEL0NAME, tsp.TSP_COMPONENTS.ABBREVIATION AS LEVEL0Abbreviation INTO
> tsp.Level_0
> FROM tsp.TSP_COMPONENTS
> WHERE (((tsp.TSP_COMPONENTS.COMPONENT_LEVEL)=0));
>
>
> Error Message.
>
> ORA-00905: missing keyword
>
> This syntax works correctly with Ms SQL and Access, why should Oracle
 work
> differently...
>
> I want the INTO command to put INTO a new table called TSP.LEVEL_0.
>
> Thanks..
>
> Peter DeSimone
> pdesimone_at_sageus.com
>
>
>
>
>
  Received on Fri Oct 16 1998 - 00:00:00 CEST