I am looking at the best way to sync an oracle database with a sharepoint list.
The sync should be done daily, with any updates to existing data shown in the sharepoint list.
It will be a one way sync, from oracle to sharepoint.

Has anyone done this?
What about third party tools?
Anyone got experience?

You can write a web service to access Oracle database. A timer job will consume this web service and update the list on a regular basis. You need to have Oracle Client installed on the machine hosting the .net web service.
Regards Prasad

-The timer job as described by Prasad is a good option
-A third party tool : http://www.simego.net/products/Data-Synchronisation-Studio
-You can also invoke web services (for instance the Lists.asmx web service)from Oracle PL SQL .

As noted below, 3rd party works great:

For on-premise SharePoint:
http://www.layer2.de/en/products/Pages/SharePoint-Business-Data-List-Connector.aspx

For SharePoint Online & on-premise (without installation at SharePoint):
http://www.layer2.de/en/products/Pages/Cloud-Connector-for-SharePoint-2010-Office365.aspx

Simply follow the videos to get an impression.

Thx, Frank