How to connect to the containerized DB

[orachard]

Hi,

How do you connect to the containerized DB using SQL Developer or VS Code?

[phartenfeller]

If all the scripts ran without errros you can use SQLcl: sql -name local-23ai-{schema_name}. Like sql -name local-23ai-sys for sys. The connections are also available from the VS Code SQLdev extension (you might need to click refresh).

Note that this only works for schemas created with the create user command.

If you need something else to connect: username/pw@localhost:1521/FREEPDB1. Passwords are stored in the .env.

[orachard]

Thanks Philipp.