By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,873 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

how to declare the cursors in a stored procedural function

P: 37
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
Feb 18 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 700
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.
Feb 18 '08 #2

debasisdas
Expert 5K+
P: 8,127
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?
.....................
Your questions are too much theoritical and is beyond the scope of this discussion . Please refer some good books for the purpose or you can easily find all that by investing some quality time in web searching.
Feb 19 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.