Re: Should TO_CHAR be replaced by high level code with pl/sql calls?

> the benefit to writing your own would rank somewhere
>around the decrease in performance one would expect to see with the line
>voltage to the computer dropped from 120V to 118V. ;-)

Good evening Daniel,

Thinking along, I did remember once seeing a company do their own date conversions from DATE to CHAR in C after it had been selected. This was back in 7.1.6 days though and written before that! and the application was very date intensive and they said it was faster to read the "raw" date and then convert it "off-line". Don't know if it really was or not!

Anyway its academic really as i don't really see the point of it all, it was just interesting to consider the "why"!!, if the voltage dropped to 118v here we would have a much bigger performance problem as we start with 240v...:-)

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.