That depends which pistol you're talking about.
For most single shot pistold nearly anything will do, for the Umarex range the oil will end up on the mag & mechanism so you'll need to use a gun oil on the moving parts as silicone oil is worse than useless where metal meets metal and will promote wear,
Regards,
Nick