How to Create Database connection using Jdeveloper ?

This blog explains about how to configure Database connection using Jdeveloper, and test SQL script statements in Jdeveloper

- Launch Jdeveloper, Choose 'Database Navigator' as highlighted below

- Right click on 'IDE Connections' and choose 'New Connection'

- Enter the Database connection details - User Name, Password, Host Name, JDBC Port Name and SID/Service Name are required fields,
- If you know the JDBC URL, then select the ' Enter Custom JDBC URL' check box, paste the URL and click on 'Test' connection.

- After successful connection, You will see newly created connection in 'IDE Connections' , expand newly created connection, Right click on it, Choose 'Open SQL Worksheet' as shown below

- You can test all SQL statement sin SQL worksheet as per below screenshot.