| |
| Having connected to the database, DB Visual ARCHITECT SQL (DB-VA SQL) allows you to execute the SQL statements and the Java code to manipulate the database. The execution result is shown immediately inside DB-VA SQL. You can check the execution result in the same environment and without using database administration tools. |
| |
|
|
| |
|
|
| Executing SQL Statement
|
|
|
SQL statements shown on the SQL editor are executable and take effects on the connected database immediately upon execution. Recent execution history for the SQL statements is recorded within the session, which allows you to execute the commonly used SQL statements easily.
|
|
|
|
 |
|
|
|
|
| Executing Java Code
|
|
|
The Java code snippet which manipulates the database using the Java Connection object is executable if the database has been connected. By adding the line of code for system output, result will show on the output pane immediately after executing the Java code snippet.
|
|
|
|
|
|
|
