"Origin: Japan. A mountain-sized serpent with 8 heads. It's said that trees and moss grow on its body, red eyes, and festering belly. It was defeated by Susano-o when Kushinadahime was about to be sacrificed to it. The sword that emerged from tis belly was called Ameno Murakumo."
—Shin Megami Tensei A-Mode DDS dictionary
Shin Megami Tensei IMAGINE
Yamata no Orochi appears as a special boss in Ueno's Kuchinawa Cave, summoned by connecting with all the plasma on the field and then killing the Onamuchi field boss. He also acts as the final boss of the Virtual Beach's Izumo island, as well as a regular Daily Mission boss for players over level 95. By offering golden sake, players are able to summon a stronger variation for a chance to obtain the ability to fuse him. He is a special triple fusion of Quetzalcoatl, Nidhoggr and Raja Naga and learns a special fire affinity spin skill at level 98.
As a playable demon, Orochi can be found in the wild at InfernalCamp Ichigaya or created through fusion. There are no special requirements to summon him, apart from Flynn being at least level 60. Orochi can teach Flynn the Bufudyne, Megaton Press and Estoma Sword skills through his Demon Whisper.
Apparently as an error in one of the game's foreign localizations, his compendium entry is actually that of Hoyau Kamui, who does not even appear in this game.
Shin Megami Tensei IV Apocalypse
Orochi is needed for the challenge quest "u have a guest!!!," in which Nanashi must fuse Yamata-no-Orochi and present him to Take-Mikazuchi in the Fairy Forest near the base of the great tree. Take-Mikazuchi will then use the Ame-no-habakiri to kill Orochi, with the blade transforming into the upgraded Ame-no-murakumo.
Orochi can teach Nanashi the Bufudyne, Agidyne, and Megaton Press skills through its Demon Whisper. It benefits from learning Physical, Fire, Ice and healing skills. Unlike most demons, its attack also strikes all enemies present.
Like in Shin Megami Tensei IV, Yamata-no-Orochi's compendium entry describes a different demon entirely.
Devil Summoner: Raidou Kuzunoha vs. The Soulless Army
Yamata-no-Orochi challenges Raidou Kuzunoha the XIV in Dark Harumi-Cho. He holds the Water Prism, one of the four components of Amatsu Kanagi. In this game, he goes by the shorter name of Orochi.
"Weakness! Weakness! You dare challenge me with just one single head? Regardless of your desire, you are not worthy! Do you think two eyes are enough to comprehend the true nature of things? All eight of my mouths shall feast upon your arrogance!"
—Orochi, battle for the Water Prism.
Persona 3 FES
"A giant snake with eight heads that fell at Susano-o's hands. The sword that came out was the Ame-no-murakumo-no-tsurugi, also known as the Sword of Kusanagi."
—Persona 3 FES compendium
Persona 4 The Animation
Yamata-no-Orochi represents the bond between Yu and his classmate Ai Ebihara. After completing his Social Link with Ai, Yu fused the necessary Personas to summon Orochi, using its power in the battles against Shadow Kanji and Shadow Mitsuo.
In the True Ending special, Yamata-no-Orochi was summoned to defend Yu against Yoshitune's attack, as well as bring a message of support for Yu from Ai.
Persona 5
"A giant snake with eight heads that Susano-o defeated to save Kushinada-Hime. The legendary sword Ame-no-Murakumo-no-Tsurugi, also known as the "Sword of Kusanagi," emerged from its belly."
—Persona 5 background
Yamata-no-Orochi is the third Persona of the Judgement Arcana and can be found as a Shadow in Shido's Palace and the Depths of Mementos, with the title "Drunken Serpents." It is the first Persona to learn the Repel Fire skill. When itemized through Electric Chair execution in the Velvet Room, Yamata-no-Orochi yields an Oni-Kagura skill card.
Yamata-no-Orochi appears as the Shadow manifestation of Politician Ooe, an ally of Shido who ordered several mental shutdowns to kill his competitors in the political world, with the most recent of deaths being the shut down of the train engineer in May to kill a diplomat in a subway crash. The party notes that it is the first instance they've encountered of a Shadow being fused with a cognition of the Palace ruler.
Devil Children
Orochi is two separate demons as Orochi and Yamata no Orochi in the series. In the English versions of Dark and Light, they are known as Orochi and Octorex.
Devil Children Black/Red Book
Rank fusing Orochi seven times can have him rank up to Yamata no Orochi.
DemiKids Light/Dark
"Huge snake-like demon that can generate large earthquakes simply by moving."
Octorex can perform the combo Wyrm Breath with Lindwurm or Wing Rox.
Digital Devil Saga: Avatar Tuner
Orochi is found in the Samsara Tunnels underneath Anahata. One of the doors to his chamber has been severely dented beyond operability and he remarks that his prey recently escaped before he could devour them. Not wanting to lose another meal, he immediately sets upon the party as they try reach the middle of the bridge in front of him.
Orochi is set apart from other bosses in that he gets 8 press turns per round and has a noticeable limit on his MP pool. He will respond immediately to -kaja and -nda spells with Dekaja and Dekunda, which will seriously cut into his MP. Once he runs out, he will stick to using Mad Rush every press turn unless he has enough MP to use MP Thief, which he will use to start another magic skill barrage if allowed. The Null Poison auto skill will protect the party from his Foul Breath attacks and Null Mute skill will prevent him from starting up another magic barrage.
After Orochi is defeated, the party can continue deeper into the tunnels and reach a seperate area of Ajna. In the upper floor hallway, a woman who was presumably the victim Orochi mentioned can be found but sadly she has passed away. The party will obtain the Red Ring key item upon examining her.
Devil Survivor 2
"A giant snake with eight heads and eight tails that appears in the Kojiki. It demanded a sacrificial maiden each year, but Susano-o got it drunk and killed it with his sword."
—Devil Survivor 2 compendium
Shin Megami Tensei: Liberation Dx2
"An eight-headed and eight-tailed serpent from Japanese lore. It's said that trees and moss grow on its body and its belly ever wet with human blood. Every year it demanded a maiden for sacrifice but was tricked and slain by the mighty Susano-o. The sword of Kusanagi was obtained by Susano-o from the tail of Orochi."