Yes, sung in my childhood as well, with the variation given on 4 November 2011, "sailing o'er a sea of dreams."
Did not Stephen King put this at a pivotal point in the plot, in his novel "Dreamcatcher"? Which I suspect was cut out of the "Dreamcatcher" adaptation for the cinema.