2 Replies Latest reply: Jan 5, 2013 7:20 AM by K_Serge RSS

    SQL Dev Child Reports - Dynamic From Clause Possible?

    Brent Grech
      Hi All,

      Trying to figure out this problem:

      Master Report SQL:

      select TABLE_NAME from USER_TAB_COLS where COLUMN_NAME = 'CREATION_DATE'

      Results with some table names. Now I want to use the table name to formulate my child query

      Child SQL:

      select * from :TABLE_NAME where CREATION_DATE >= SYSDATE-7

      or whatever.....but I want to somehow use the table_name dynamically.

      Thanks!
      -Brent