This whole debate is ridiculous, much like Texas perennially threatening to defect. No way that the UK would let Scotland leave with the oil revenues. There is that other article that points out that if Scotland defected, the Shetlands (oil revenues) would have an equally good claim to leave Scotland too.
Then what would Scotland be? The sucking welfare hole that swallows a huge amount of UK tax money, without any more tax money to support it. I.e. the poor backwater of a frontier country it once was...