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.
