Unanswered: how many times will the function executed when selected/called from a query statement
How many times the function of to_date will be executed when run the following query? Will it run 1000000 times? will Oracle cache the result of the function? How can we approve whether to_date run 1000000 times or just once?
select to_date('20070817','YYYYMMDD') from tab_with_1000000 rows