The MacBook Air and the latest Mac Mini don't have an internal SuperDrive, but can share a DVD or a CD from another Mac.
At the time or writing, this is not true for the MacBook Pro. My previous post explains how to use the MacBook Air SuperDrive with any Mac, but you might be interested to simply mount a DVD/CD from another Mac (or Windows conmputer).
Type the following commands in Terminal to enable Remote Disc to appear in your Finder sidebar:
defaults write com.apple.NetworkBrowser EnableODiskBrowsing -bool true defaults write com.apple.NetworkBrowser ODSSupported -bool true
… and restart your Mac.
This is useful tip when you've swapped out your optical drive from your MacBook Pro.