Re: Select Into Statement

Is the "into" using a variable called test? It seems unclear from your post

kent.davis_at_tsa.advet.com (KED) wrote in message news:<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 Thu Apr 25 2002 - 03:57:21 CEST