You're thinking heated Vs. non-heated narrowband sensors. Heated narrowband function exactly the same as narrowband, but have a heating element in them to bring them up to temp quicker & during extended idle where a non-heated sensor could cool off. The heating element in them requires a few extra wires, which can be run off a relay if you want to upgrade.
Wideband is an entirely different type of setup, it uses its own computer and usually has a one-wire output from its controller to emulate a stock narrowband sensor so the ECU stays happy. They have 5-9 wires to the sensor depending which one you get