SQL:

## Used for show table name whose column name is user input :

SELECT TABLE_NAME FROM USER_TAB_COLUMNS
WHERE UPPER(COLUMN_NAME)='COLUMN_NAME'

     Sub query :

select  appoint_date,doc_name,doctor_no,doc_chember, sum(tot_app) tot, sum(in_pat) in_pat,
(select room_name from hpms_room where room_no=a.doc_chember) room_no
from(
    select appoint_date,doctor_no,doc_chember, doc_name,tot_app,  in_pat
    from
         (select appoint_date,doctor_no,doc_chember,fnc_doctorname(doctor_no) doc_name,count(APPOINT_NO) tot_app,(select count(APPOINT_NO) from op_patientmovement
        where trunc(entry_timestamp) between  trunc(sysdate-120) and sysdate and consult_no = a.appoint_no and movement_type_no=6 ) in_pat
        from op_appointment a
        where trunc(appoint_date) between  trunc(sysdate-120) and sysdate
        and trunc(appoint_date) between nvl(to_date(:p_form_date,'dd/mm/rr'), appoint_date) and nvl(to_date(:p_to_date,'dd/mm/rr'),appoint_date)
        group by doctor_no,appoint_no,appoint_date,doc_chember)
    )    a
group by doc_name,appoint_date,doctor_no,doc_chember
order by appoint_date desc;

-----------------------------------------