Please explain me the difference between a Function and a Procedure.
One of the major differences i read/heard is DML statements cant be written in a Function. But one of my colleagues proved it wrong.
So please some one make me understand deeply. Is this feature new one? or its been there since long? if its been there since long, then why is it written everywhere like that?