We spent a night there during a road trip out of Edinburgh. We did not spend too much time hanging around. Apparently, the city depends on the oil drilling industry in the North Sea these days for its existance.
https://en.wikipedia.org/wiki/Aberdeen