VIDEOS:
Sans's "Sexy Burger Dreams"
Ask Frisk and Company provides a G-rated example. While the dream starts off chaste (if weird), things take an... interesting turn when Toriel comes in wearing a nurse outfit. The askers wake up Sans before anything really happens though, much to his dismay.
Example of:
Erotic Dream