Re: better sql code
- From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
- To: oracle list <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 28 Oct 2005 13:21:44 +0800
Whilst I agree with the external table idea, perhaps the quickest of quick
changes would be to add 'alter session set cursor_sharing = force' to the
script to at least make the update's all sharable.
hth
connor
--
Connor McDonald
===========================
email: connor_mcdonald@xxxxxxxxx
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
Other related posts:
