hi , can anyone help how to use median function in oracle to be used in hibernate .how to use median function in hibernate . we are using oracle as a database using hibernate .
HQL doesn't have a median function itself. But the is nothing to stop you running propriatory SQL via Hibernate. Have a look at Session.createSQLQuery(). Alternatively you can do this with a named query. [ July 16, 2008: Message edited by: Paul Sturrock ]