Long exposure photography, in simple terms, is keeping shutter open for long duration. This can produce extraordinary results in night photography and landscape photography.
The basic requirement is a tripod or some stable base. You can even use your car top also. The idea is to keep the camera stationary while shutter is open.
Other aspects to be kept in mind is to use low ISO to reduce noise or grains in the picture and aperture between f/9 to f/22.
The picture was taken during night on a road with moving cars giving the effect of street on fire due to blurring effect of lights of moving cars ( Exposure 30 sec, ISo – 100 and aperture – f/11).