If you want to listen to the actual tune Black Bear, it's on Youtube, played by the Royal Scots Dragoon Guards.
Heard it loads of times at the end of the Edinburgh Tattoo, but not sure about the advert.