I'm a first time poster and I'm new to SQL Developer. I've worked a lot in SQL Management Studio but SQL Developer is different.
Your question has NOTHING to do with SQL Developer but, as the forum title says, this forum is NOT for SQL or PL/SQL questions.
Generally you would return a REF CURSOR to the client and the client would then fetch and process the result set.
You could also return a SQL COLLECTION (nested table) or use a PIPELINED function as I show in my reply in this thread.
Please do NOT follow up here but instead mark this thread ANSWERED and repost your question in the SQL and PL/SQL forum.
There, there, there rp.. .
Shouting at first time posters, how tempting it may be, isn't really going to encourage OP to participate or make him/her more willing to learn. Not sure if that's what you want.
But you gave a few good pointers, allow me to add some more profound explanations and examples for OP:
Without knowing knowing a database version and a little bit more regarding the exact specification, I would not recommend nested tables.
Oh and to OP, make sure to read:
And explore (depending on your exact database version):
because they contain the The Tom Kyte Blog: The keys to Oracle…
Do we really need to yell at posters?
Nobody yelled at anyone. That appears to be an assumption that you are making for some reason. Use of caps is just a way to add emphasis.
There is absolutely NOTHING (and that isn't 'yelling' either) in my post that is inappropriate at all.
1. It points out that this is the wrong forum and refers to the forum title to reinforce that
2. It directs OP to the proper forum
3. It provides one example that addresses OPs question even though it was posted in the wrong forum.
Many people (myself included) perceive the use of capitals as shouting - it is a very common perception. Fragments like "wrong forum" rather than whole sentences "This is the wrong forum for that sort of question" increase the sense of being shouted at. With that perception, many of your posts appear quite grumpy. Perhaps you are just using capitals for emphasis, and my impression does not match your attitude, but two other people felt it was worth commenting about too.
Well now that everyone knows that it isn't really shouting they can begin the work of changing their perception to fit the facts.
I consider these to be professional forums for technical questions and issues that require technical answers. They aren't really the place for people that need TLC embedded in every comment.
As far as my forum replies there is NOTHING personal in the comments or answers; it is ALL technical. You are certainly free to perceive my posts as 'grumpy' if you want but not only is that your own perception, formed by your own experiences and prejudices but even posting such irrevelant opinions in the forums serves no useful purpose whatsoever and those personal 'interpretations' will often be wrong (as in this case) since they aren't really based on any 'knowable' facts. In short their expression is wasted effort.
I don't see it as productive or useful to clutter up the forums with commentary that isn't directly related to the issues presented. That is just too distracting IMHO. To me it is just plain silly to go back-and-forth about 'who' considers 'what' to be shouting. Just look at all of the meaningless space taken by the last few posts that have NOTHING to do with helping OP or others with their technical issues.
I prefer to stick to facts as I did in my earlier posts: wrong forum, provide the correct forum, give a helpful example.