I would like to know if there is any default oracle view for all Country name/Nationality which we can use for dropdown list of oracle apex application after giving access to application schema.
Your suggestions would be helpful.
No there is not. You'll have to create your own. However, in apex that should be a breeze. Copy and paste the list of countries from any wiki in an excel file (or download from here) and use the data workshop to load it into a table.