I am trying to copy data from DBMS perspective -> file explorer -> data -> [my_app_package]then PULL this is working when I am running application on emulator but when I am running application on mobile nothing is shown under data folder.
I have also tried to do same thing from adb but its not working. Is their any way to explore SQLite database created by my application without rooting my phone.
No you can't, However you can use logs to fetch and see the fetched data in logcat or set some value on your textviews or use table layout to see your fetched data.
If you are using a Real Device and it is not rooted then it is not possible to see you data base in FileExplorer because due to some security reason that folder is locked in android system. and if you are using it in an emulator you will find it in FileExplorer /data/data/your package name/databases/yourdatabase. db