There's been a rumor flying around the blogosphere that it's actually possible to return more than a single value from a database query. I've done a little research on this, and from what I can tell, it's true! In fact, you can return a whole set of data. Even in Oracle!

I'll bet Steve Mitchell's colleague is pleased. He'll no longer have to build long strings with non-text characters as deliminters and pray it'll work in his text editor. Just look at all the trouble it was ... I'll even bet the little box character (in the second block ... the first is an image) doesn't even show up for half of you.

Database Code (PL/SQL):

Front End Code (PowerBuilder)

Update: FireFox users were reporting bugs when trying to read the non-text characters on the webpage. I took a snapshot of it in IE and changed it to an image.

[Advertisement] BuildMaster allows you to create a self-service release management platform that allows different teams to manage their applications. Explore how!