String sql = "select table_name from all_tables where owner='YOUR_DB_SCHEMA_NAME'";

Query q = session.createSQLQuery( sql );
List names = q.list();
if ( names != null && !(names.isEmpty()) ) {
   int length = names.size();
   for ( int i=0; i<length; i++ ) {
      Object object = names.get( i );
      System.out.println("object = " + object.toString());
   }
}

SessionFactory factory =HibernateUtil.getSessionFactory();
Map metadata = factory.getAllClassMetadata();
Iterator it = metadata.entrySet().iterator();
while ( it.hasNext() ) {
   Map.Entry entry = (Map.Entry) it.next();
   Object key = entry.getKey();
}

String sql = "select * from all_tables where owner='EMPLOYEE'";

Query q = session.createSQLQuery( sql );
List names = q.list();
if ( names != null && !(names.isEmpty()) ) {
   int length = names.size();
   for ( int i=0; i<length; i++ ) {
      Object object = names.get( i );
      if ( object instanceof Object[] ) {
         Object[] cols = (Object[]) object;
         for ( int col=0; col<cols.length; col++ ) {
            System.out.print( cols[ col ] + " | ");
         }
      }
   }
}

String sql = "select table_name from all_tables where owner='YOUR_DB_SCHEMA_NAME'";

Query q = session.createSQLQuery( sql )
                   .addScalar("table_name", Hibernate.STRING);
List names = q.list();
if ( names != null && !(names.isEmpty()) ) {
   int length = names.size();
   for ( int i=0; i<length; i++ ) {
      String tableName = names.get( i );
      System.out.println("a table name = " + tableName);
   }
}