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

Peter DeSimone wrote:
>
> 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.
>

Peter,

Try something like this:

INSERT INTO TSP.LEVEL_0
SELECT tsp.TSP_COMPONENTS.ID AS LEVEL0ID, tsp.TSP_COMPONENTS.NAME AS LEVEL0NAME, tsp.TSP_COMPONENTS.ABBREVIATION AS LEVEL0Abbreviation INTO FROM tsp.TSP_COMPONENTS
WHERE (((tsp.TSP_COMPONENTS.COMPONENT_LEVEL)=0));

Yours,  

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Fri Oct 02 1998 - 00:00:00 CEST