Hi all,
I am new to hibernate.
I need to fetch list of rows from db in which one field should be fetched from pl/sql function and all the others from date base colums.
How to call this pl/sql function in each row for fetching my customized column and other column from DB.
eg:
I want to call this kind of query using hibernate.
select student_id,student_name,student_class,is_scholer_ship_eligible(student_id) as scolership_eligiblity from student where student_class = 10;
Here student_id,student_name,student_class come from db column and
scolership_eligiblity comes from a function return.
In the above example the function is_scholer_ship_eligible is called passing student_is as parameter.Is this possible to call the same kind of scenario using hibernate.
Kindly assist me.
Thanks and Regards
Navas Khan.
|