0 Replies Latest reply: Mar 1, 2012 5:26 AM by Venkat RSS

    How to get subquey column name in 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