Home -> Usenet -> comp.databases.oracle -> Select Into Statement

Select Into Statement

From: KED <kent.davis_at_tsa.advet.com>
Date: 24 Apr 2002 08:03:30 -0700
Message-ID: <c4e62fbe.0204240703.76b3828d_at_posting.google.com> 






Can anyone explain why this statement does not work.



select tableid into test from recnoctr where tableid = 'set';



When this statement is run in SQL Worksheet or SQL Plus the following error occurs:



select tableid into test from recnoctr where tableid = 'set';

                    *




ERROR at line 1:


ORA-00905: missing keyword



Any help is appreciated.



Kent
Received on Wed Apr 24 2002 - 17:03:30 CEST












Original text of this message