title: How to write HQL query to select all columns using * in oracle?
body: <p>I want to select all columns from oracle DB using query : 
  <strong>SELECT  r.* ,  COUNT(*) OVER () TOTAL_COUNT FROM (select tables_columns from table) r</strong> </p>
  
  <p>I am able to execute this using <strong>session.createSQLQuery(query)</strong> but i need to use hibernate query <strong>session.createQuery(hql)</strong> to execute my sql query, here i am facing issue. the issue is hibernate not able to recognize  * and 'OVER' keyword. Hibernate doesn't understand r.*</p>
  
  <p>How can i use hibernate query to do this operation ?</p>
  
  <p>one way is to select all columns using ' r.column_name for all columns' but i need to use something similar to SQL query.</p>