Quote:
Originally Posted by san1014
Hi
I have few questions.
Pleae give me the answers.
1) In postgreSQL, how to declare and call the cursors in a stored procedural function?
Ex: I want to display all the columns in a table in one cursor
and also how to see the output.
2) tell me , the analytic functions in oracle connect by prior,
sys_connect_by_path are existed in postgreSQL?
3)how to call the stored procedural function which was written in postgres in java?
Thank you
Ad 1) for cursors see
here
Ad 2) i'm sorry i don't know what are you talking about, i don't know oracle
Ad 3) what do you mean saying "written in postgres in java"? you mean written in pljava? if so i think you can call it like every other function usually using select command.
