What unit submarine types ship Norway?
Vessel Origin Type In service Unit
3rd Ship Flotilla
18952568
text text text real text
2-18952568-1
Vessels
Vessels
Oliver Hazard Perry class United States Frigate 2 Anti-Submarine Unit
Kobben class Norway Submarine 4 Submarine Unit
Kilo class Soviet Union Submarine 1 Submarine Unit
Orkan class East Germany Fast Attack Craft 3 Missile Vessels Unit
Tarantul class Soviet Union Corvette 2 Missile Vessels Unit
Project 888 Poland Training Ship 1 Support Unit
Project 281 Poland Rescue Ship 2 Support Unit
Project 5002 Poland Rescue Ship 2 Support Unit
Project 863 Poland Reconnaissance Vessel 2 Reconnaissance Group
SELECT Unit FROM table WHERE Type = submarine AND Origin = norway
submarine norway