first notice you are posting in the wrong forum. This one is devoted to the sqldeveloper IDE itself, not Oracle sql/programming questions. You should try SQL & PL/SQL next time
Having said that, i believe what you are looking for are "pipelined functions". Their result can be cast to a table and perhaps wrapped in a view to make it look like a regular view to a reporting tool.
Thanks B.Dalmee, and sorry about i go to wrong forum. I will move to there now.
I see your other post in the PL/SQL & SQL forum.
For future reference:
- I believe you can move your post to the correct forum yourself.
- If not, you can always ask a forum admin to move it for you by doing a "report post" (there is a drop down that you use to select "wrong place")
Also, you can change your displayed nickname by watching this video:
Finally, we kindly ask that you close your threads by marking the most appropriate response as "correct answer" or marking the entire thread as "assumed answered".
In this case, since you have a lot of responses in the other thread, please mark this one as "assumed answered".
And: welcome to the forums.