Create Java application named "ShowCountriesByRegionName" which will query the regions and countries tables in your Oracle database for the countries name by a given region name, such Americas. Users should enter the region name in the console, and the application displays the countries' names in the console. Use Oracle thin database driver to implement the connection.

Important note: Never hard code your username and password in your Java application. You must create java file called "UserPass.java" then declare and define your "USERNAME" and "PASSWORD" as final static fields in it. Never submit "UserPass.java" file as it contains your private information.-10% deduction if you do not follow this note.