INSERT INTO with SELECT
From: David Small <SmallD_at_csi.com>
Date: 1998/01/26
Message-ID: <01bd2a61$ea492b60$3b81170a_at_smalld>#1/1
Date: 1998/01/26
Message-ID: <01bd2a61$ea492b60$3b81170a_at_smalld>#1/1
Hi-
If I use an INSERT INTO clause, followed be a SELECT clause, followed by an ORDER BY clause I receive an error message ("SQL command not properly ended"). If I remove the ORDER BY clause, the statement works fine. Is there a way to include the ORDER BY clause in Oracle? Most other RDBMS's permit it in the INSERT INTO/SELECT statements.
Thanks-
David Small
Blessing/White, Inc.
Received on Mon Jan 26 1998 - 00:00:00 CET