SQLTools[^] if you want it lightweight. TOra[^] is at the other end of the spectrum. Both are opensource. SQL Developer and Oracle Developer Tools for Visual Studio has already been mentioned. They are from Oracle and are supported, ... sort of. You will also need to install some version of the Oracle Client which is available in several versions such as the normal Client, Instant Client or Oracle Data Provider for Dotnet. Oracle Developer Tools for Visual Studio has the Client built in.
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions