Actually both SQL server and Oracle does give you access to remote objects .SQl calls it Linked server objects, which links to external database fromwhich you can create your tables and views.

Oracle provides the same functionality, in a little more complex way, and it is calld database links or db links, but you need a what is called a Oracle Trasnparent Gateway.