Can you plug a motion detector light into an outlet?

Yes of course, power is power, all 110volt, what ever the source in your house (except a dryer circuit that is usually higher).

The difference is the amperage of the circuit. Lighting circuits have amperage controlling breakers that are usually 15amp, power circuits are usually 20amp but excepting a very very unusual condition you would not need to worry about it.