Trying to run a SELECT...INTO SQL Command

[Quoted] [Quoted] 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 [Quoted] [Quoted] differently...

[Quoted] 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 02 1998 - 00:00:00 CEST