Re: storing data horizontal vs vertical using pl/sql

Hmm, Norman, I don't think that's because Raj asks how to do it with PL/SQL that I would feel compelled to do it with PL/SQL ...  An INSERT ... SELECT can do it as well, and much faster ...

I know what you are going to say about committing, but it would allow you to do it in direct mode ...

HTH S Faroult

--
http://www.freelists.org/webpage/oracle-l