In this continuation article we shall connect to the database instance with Toad for Oracle.

Select the Direct tab and specify Host as the Public IP of the database instance.

Specify Service Name as the service name obtained from the Connect String.

Select the TNS tab and click on TNSNames Editor to create a new network service as shown in Figure 6.

To add a new net service name select Add Network Service as shown in Figure 7.

Select Connection Type as Default Database as shown in Figure 9.

With the TNS tab selected select the Database OraDB18C from the drop-down as shown in Figure 12.

Copy the SQL Script to an SQL Editor and click on Execute as script as shown in Figure 15.

Select a schema ( SYS ) and a table ( WLSLOG ) to display detail on, as shown in Figure 18.

Specify a SELECT statement in the SQL Editor associated with the connection and click on Executecompile statement at caret as shown in Figure 27.

The instance starts to get stopped, as indicated by a message shown in Figure 41.

The benefit of using Toad for Oracle is an integrated development environment (IDE) with all the features to connect to a database, create and manage connections, create and manage database objects, run SQL scripts, browse schemas and generate reports in various output formats including CSV, HTML, and Excel.

Toad For Oracle 11G Torrent