title: Query returning current connection details in Oracle
body: <p>My Java EE application is pointing to an unknown Oracle database and I need to check from the application the database host name, its SID, current user and connection port.</p>
  
  <p>I have no access to the database connection details because my application uses a data-source provided by the application server (Weblogic 11g) and I have no access to its admin console. I have the application's source and I can deploy and debug a new version of it in the server.</p>
  
  <p>How can I get the current database user, database host and service from the current connection?</p>