Manual transmission cars use a type of oil that is similar to engine oil but its viscosity is thicker. Automatic transmission cars need a specific fluid called ATF. You should always use the type of oil indicated in the owner's manual of the car or an equivalent one. You should also respect the oil change intervals.