SQL*Plus: Select in select

Hello,

[Quoted] In a book about the SQL ANSI92 Standard I read about a way to put an SQL-select in a select, like i.e.:

select t1.col1

     , t1.col2
     , ( select t2.col1
         from   table2 t2
         where  t2.keyval = t1.keyval
        )  col3

etc.

However, in SQL*Plus (3.3.2 on Oracle 7.3.4) I get an error (ORA-00936: missing expression) on the first line of the second SQL. Is this feature not supported by Oracle? Or maybe in Oracle8?

TIA Henk Hultink
Stoas Informatisering
"Activating Knowledge"
Wageningen
The Netherlands Received on Thu May 18 2000 - 00:00:00 CEST