Re: Slight "I have some string, how lng it it, BTW, it's blue" question

Basically, the rule of thumb I use is if it can be done with SQL statements, do it in SQL. If not, then use PL/SQL.

If you use a view and query from the view, you are using a SQL solution. Using cursors to do your join will usually be slower than doing it with a well-formed SQL statement.

Cursors are not the fastest mechanism if you are using PL/SQL. Array processing is much faster. Daniel Morgan has posted some examples here:

http://www.psoug.org/reference/bulk_collect.html

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown