PopSQL supports Oracle DB 12c and newer. If you wish to use PopSQL with an older version of Oracle, please get in touch.
Note: PopSQL supports Oracle only as a direct connection.
- Open the connections page in preferences, see managing connections for more information.
- Click the
Add new Connectionbutton at the top of the connections page.
Oraclefrom the list.
- Give a
Connection namefor your own internal reference.
Hostname, enter the hostname of your database server.
Port, use the default
1521, or enter the port used by your server.
Database, enter the name of your database.
Password, enter the username and password for Oracle. These are optional.
Role, select the role you normally use to connect to your Oracle server (e.g.
SYSOPER, etc). This is optional.
- Share the connection with your team.
SSLsettings. These are optional.
Connectand you're all set!
Happy querying! 🍭
Updated 6 months ago