server side installation

i would like to know if any software say oracle8 can be installed on a server and the workstations connected to this server can run oracle applications without the need for local installations of the software on workstations.