Now that you have your SQL Developer up and running and have your new connection windows open, you are all set to start the process of connecting with a pluggable database in Oracle Database 18c. Info: If you can’t see the connection tab on your screen then, go to the View menu and click connections. You can open a new connection window by clicking the big green button in the connection tab. Once you have started your SQL Developer next you have to create a New Connection and you can do so by opening a new connection windows.
How silly of me to point out the obvious. Yep, first thing which you have to do is to start your SQL developer. Start the processīefore we start the process of connecting with a pluggable database we need to get our desired GUI that is SQL Developer, up and running. I have done a tutorial on how to Install SQL Developer on Windows which you can watch here. Steps will remain the same.Īlso, in order to learn either of these processes you will need SQL Developer Installed on your machine.
It could be a sample schema or a user defined schema. Similar to SQL*Plus CLI, with SQL Developer also, there are two ways of connecting with a Pluggable Database in Oracle Database 18c.įor the demonstration I will be using HR sample user to establish a connection with the database but if you want you can use any sample schema/user.
0 kommentar(er)
