Whenever Link is about to enter a door, the camera swings around so that Link and the door are centered on the screen. In some places, it is possible to get the camera stuck at this angle.
Walk up to a door so that the camera changes its position, then use C to enter first person mode. Stand on the right side of the door and hold up and right while looking to the left, so that the camera view starts to jitter. Once the camera is jittering, exit first person mode and immediately run backwards out of the door zone. If done correctly, the camera will remain at the same angle, and will not rotate around Link as he moves.
The camera will become stuck in place with the following exceptions:
This camera lock has no known uses at this time.
If you interrupt the skulltulla death animation with a bomb explosion, the skulltulla's dark corpse will never vanish.
In Skyward Sword, it is possible to get a long jump attack by targetting something that is standing above ground that is higher than you. It does not give enough extra distance to have any uses in speedruns currently.
While the minigame owner only asks for 10 rupees, you actually need 20 rupees to play the Clean Cut minigame.
This glitch is famous and prompted Nintendo to release a patch. This only occurs on the NTSC-U 1.0 version. After meeting with Levias, go to Lanayru and talk to Golo the Goron in the Lanayru Mines. Then complete the Lanayru Song of the Hero quest. Once that is done, go back to the Lanayru Mines and talk to Golo again. This will set the flag that you have started the Lanayru Song of the Hero quest again, despite the fact that you've already completed it. This makes it impossible to start the other quests.
Contrarely to popular belief, the glitch is not related to doing the Lanayru Song of the Hero quest first. It can also happen when doing it second.