1 Reply Latest reply on Mar 1, 2012 8:26 AM by Venkat

    How to get subquery field in the output

    Venkat
      Hi,

      How to get segment_name in the output.

      select file_name,tablespace_name form dba_data_files where tablespace_name in(SELECT a.tablespace_name from dba_data_files a,user_segments b
      where a.tablespace_name=b.tablespace_name and b.segment_name='EMP')

      Regards,
      Venkat