Connecting to Oracle

1. Click Manage Connections in the top center of the app.

2. Click New Connection in the Manage Connections modal in PopSQL.

3. For Nickname, enter something a descriptive name for your connection, like Acme Production.

4. For Type, choose Oracle.
5. For Hostname, enter the hostname of your database server.
6. For Port, use the default 1521, or enter the port used by your server.
7. For Service Name, enter your the name of your database.
8. For Username and Password, enter the username and password for Oracle. These are optional.
9. For Role, select the role you normally use to connect to your Oracle server (e.g. SYSDBA, SYSOPER, etc).
10. Hit Connect and you're all set!

Happy querying! 🍭