The Van Gogh one is considerably longer than quoted above.

My name it is Van Gogh,
Lend an ear, lend an ear.
My name it is Van Gogh,
Lend an ear.
My name it is Van Gogh,
And all I did was cough,
And me right ear it fell off,
In me beer, in me beer.

Plus at least one more verse.

There are some others of the same kind as quoted by Mr Red, for example:
Oh dae ye see yon high hills, a' cover't wi' snaw?
Na!