title: Get Specific Column Names in SYNONYM in Oracle
body: <p>With this query I can successfully get a list of  column names for an Oracle table.</p>
  
  <pre><code>SELECT COLUMN_NAME
  FROM USER_TAB_COLUMNS
  WHERE table_name = 'TBL_NEWS' 
  AND COLUMN_NAME LIKE ('GLOBE_%') 
  ORDER BY  COLUMN_ID
  </code></pre>
  
  <p>I have a synonym and I need to get all column names of that synonym also. So how can I extend above query to get all column names in Synonym starting <code>GLOBE_</code> ?</p>