How to configure database connection in PL/SQL?

To set up PL/SQL Developer to connect to the database, follow these steps:

1. Open PL/SQL Developer.
2. Click on the “Connect” button in the toolbar or select the “File” > “Connect” menu option.
3. Select “Oracle” as the database type in the “New Connection” dialogue box.
4. Input the following information in the “Connections” tab.
5. Username: Input the username for the database connection.
6. Password: Enter the password of the database user.
7. Host: Enter the hostname or IP address of the database.
8. Port: The port number used to input into the database. By default, Oracle database uses port 1521.
9. Please provide the name of the service for the database. If you are unsure of the service name, please reach out to the database administrator.
10. Click the “test” button to test the connection.
11. If the connection is successful, click the “OK” button to save the connection configuration.

Now, you can connect to the configured database using PL/SQL Developer and start writing PL/SQL code.