Well, I have to admit that I mainly thought about "self-replicating" resources (i.e. animals, plants, ...).
But ... oil well yields adhere to an bell-shaped curve. So, yes, for some time you'll see an increase while you extract the oil. Now, at least in Civ4, natural resources don't deplete...