Re: SQL*Plus: Select in select
From: roger <roger.trollerNOroSPAM_at_trivadis.com.invalid>
Date: 2000/05/18
Message-ID: <070dbf92.19a2318b_at_usw-ex0108-062.remarq.com>#1/1
WHERE a.column_name = v.column_name
/
Date: 2000/05/18
Message-ID: <070dbf92.19a2318b_at_usw-ex0108-062.remarq.com>#1/1
This feature is available with ORACLE 8i (8.1).
With ORACLE 7.3.4 you could write SELECT statements like
SELECT a.column_name
,v.column_name
FROM table a
,(select column_name
from table) v
WHERE a.column_name = v.column_name
/
you are allowed to use immediate views which are located in the from clause.
- Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful