3 Replies Latest reply on Jul 31, 2018 10:29 AM by 3750943

    Oracle SQL Developer Reports

    3750943

      Hello All,

       

      My objective is to create a User Defined Report in SQL Developer by querying multiple tables. But am unable to create a report with multiple select queries.

      So I have tried using UNION ALL between the select queries and I got the count.

       

      SELECT COUNT(*) FROM TBL_A WHERE ....

      UNION ALL

      SELECT COUNT(*) FROM TBL_B WHERE ....

      .......

       

       

      But, I would actually need the table name and the count in the below format.

       

      Table_nameCount
      A10
      B10
      C10
      D10
      E10

       

      Could someone provide any better options ?