we have an oracle apex application running on our LAN, we want to use the same on Android based tabs. I'm a little confused how to go about it as we have no Internet access on our office PCs on which the app is running and same SOP will be applied on Android based tabs.
and we said...
As long as the Android devices are on your local LAN (presumably via wifi) then you can use your APEX apps like any device on the network. Universal theme is a responsive theme that will adjust the layout based on the device type, and similarly, browers like Chrome/Firefox etc let you work in a mode to simulate various devices so you can check how it all will render.
If you want to use APEX *without* having access to the database server via the network, that is a much more challenging exercise, because APEX *needs* the database.
In that case, you'd be looking at a progressive web app to minimise the connectivity
A good video on that here