I am a hospital pharmacist

Can openEMR be used in a hospital Pharmacy?

Yes.
https://www.open-emr.org/wiki/index.php/Pharmacy_Dispensary_Module