Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagenone
> dbviscmd.bat -connection "OracleVirtualBoxOracle" -sqlfile "myscript.sql" -output log
14:32:18select * START Executing Command Line, Database Connection: OracleVirtualBox Database Type: ORACLE Catalog: null Schema: SYSTEM
14:32:18  INFO  Physical database connection acquired for: OracleVirtualBox
14:32:18  SUCCESS  [INSERT - 1 rows, 0.006 secs]  OK
INSERT INTO HR.REGIONS (REGION_ID, REGION_NAME) VALUES (5, 'Australia');
14:32:18  SUCCESS  [INSERT - 1 rows, 0.004 secs]  OK
INSERT INTO HR.REGIONS (REGION_ID, REGION_NAME) VALUES (6, 'South America');
14:32:19  END Execution from hr.countries;
INFO: 16:52:56  [SELECT - 25 row(s), 0.013 secs] Result set fetched
select * from hr.regions;
INFO: 16:52:56  [SELECT - 4 row(s), 0.002 secs] Result set fetched
SUMMARY: ... 2 statement(s) executed, 229 row(s) affected, exec/fetch time: 0.010015/0.000002 secssec
  [2 successful, 0 warnings, 0 errors]

Combining OS scripts, the command line interface and DbVisualizer variables

...