title: How to Query Database Name in Oracle SQL Developer?
body: <p>How do I query the database name in Oracle SQL Developer? I have tried the following and they all fail:</p>
  
  <p><code>SELECT DB_NAME();</code></p>
  
  <p><code>SELECT DATABASE();</code></p>
  
  <p>Why do these basic MySQL queries fail in SQL Developer? Even this one fails too:</p>
  
  <p><code>show tables;</code></p>
  
  <p><strong>EDIT:</strong> I can connect to the database and run queries such as:</p>
  
  <p><code>select * from table_name_here;</code></p>
  
  <p><strong>EDIT 2:</strong> The database type is <code>Oracle</code>, this is why <code>MySQL</code> queries are failing. I thought it was related to the database client not the database itself. I was wrong. I'll leave the question as is for other as lost as I was.</p>