Is it possible to call a Stored Procedure within the OraCmd ? Yes, You can. For example, you have a Oracle stored procedure “test_procedure”, create or replace procedure test_procedure is begin delete from employees where employee_id < 100; end test_procedure; In OraCmd, you ... Read more
Tag Archives: Oracle
How to execute sql file via command line for Oracle
Use sql*plus run SQL file sqlplus username/password@databasename @/path/to/test.sql If you want to see whats going on like this, including any error messages, you need connect to SQL*Plus with sqlplus username/password@databasename Then run the script from the SQL*Plus prompt: set echo ... Read more
Withdata Software Released OraLobEditor 3.6
Withdata software has announced oralobeditor 3.6, a tool that helps you edit Oracle lob(clob,blob) data directly. OraLobEditor 3.6 add “Task Schedule”, improve import/export performance, and fix “division by zero” bug in importing/exporting process. OraLobEditor – ... Read more
Withdata Software Released OracleToMysql Version 1.3
Withdata software has announced oracletomysql 1.3, a data conversion tool that convert Oracle data to MySQL database. Version 1.3 add “Task Schedule”, improve importing performance, and fix “division by zero” bug in importing process. OracleToMysql – convert Oracle ... Read more
Withdata Software Released OracleToMsSql Version 1.3
Withdata software has announced oracletomssql 1.3, a data conversion tool that convert Oracle data to SQL Server database. Version 1.3 add “Task Schedule”, improve importing performance, and fix “division by zero” bug in importing process. OracleToMsSql – convert ... Read more
Withdata Software Released OracleToDB2 Version 1.3
Withdata software has announced oracletodb2 1.3, a data conversion tool that convert Oracle data to DB2 database. Version 1.3 add “Task Schedule”, add support to DB2 XML type field, improve importing performance, and fix “division by zero” bug in importing ... Read more
Withdata Software Released MysqlToOracle Version 1.3
Withdata software has announced mysqltooracle 1.3, a data conversion tool that convert MySQL data to Oracle database. Version 1.3 add “Task Schedule”, improve importing performance, and fix “division by zero” bug in importing process. MysqlToOracle – convert Mysql ... Read more
Withdata Software Released MsSqlToOracle Version 1.3
Withdata software has announced mssqltooracle 1.3, a data conversion tool that convert SQL Server data to Oracle database. Version 1.3 add “Task Schedule”, improve importing performance, and fix “division by zero” bug in importing process. MsSqlToOracle – convert SQL ... Read more
Withdata Software Released DB2ToOracle Version 1.3
Withdata software has announced db2tooracle 1.3, a data conversion tool that convert DB2 data to Oracle database. Version 1.3 add “Task Schedule”, add support to DB2 XML type field, improve importing performance, and fix “division by zero” bug in importing ... Read more
Withdata Software Released OracleToAccess Version 2.2
Withdata software has announced oracletoaccess 2.2, a data conversion tool that export Oracle data to access. OracleToAccess 2.2 add “Task Schedule”, improve importing performance, and fix “division by zero” bug in importing process. OracleToAccess – Better tool for ... Read more