returning multiple records - URGENT

 
HELLO,

How to retrieve the 1 row as well as multiple rows from a table using functions.
Is there any data type that returns entire row.
I tried cursors, but the problem is when i try to run this function from java it returns only the first row.
Please HELP ME!
 
bye
ram