1 person found this helpful
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.
1 person found this helpful
Do we really need to yell at posters? The distinction between the database engine and SSMS in the MSFT space is very very weak. It's not so unreasoanble for a new person to bec confused and accidentally post here.
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…
Thanks for your replies everyone.
Sorry if this was the wrong forum. I didn't see any other forum a question like this might go under.
Thanks to rp for giving me the link to the right forum.
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.
All caps and ! is yelling on the internet, and it's not appropriate on our forums. Letting said behavior go without bringing it to your attention is the same as endorsing such behavior, and that I will not do.