Subquery in from clause : Subquery IN « Subquery « Oracle PL / SQL

1. Oracle PL / SQL
2. Subquery
3. Subquery IN

Subquery in from clause

  

SQL>
SQL> create table myTable
  2  as
  3  select rownum id, a.*
  4    from all_objects a
  5   where 1=0
  6  /

Table created.

SQL>
SQL>
SQL> select *
  2    from myTable myTable1, ( select owner, max(last_ddl_time) max_time from myTable group by owner ) myTable2
  3   where myTable1.owner = myTable2.owner
  4  /

no rows selected

SQL> drop table myTable;

Table dropped.

   
    
  

Related examples in the same category