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
Category Archives: OraCmd
Withdata Software Released OraCmd Version 2.7
Withdata software has announced oracmd 2.7, a command-line tool that can run SQL command, import/export data, even without Oracle client. OraCmd 2.7 add a pure x64 version, add “use date time format as export file name”, and fix bug of record delimiter as crlf. OraCmd – The ... Read more
OraCmd Update: keeps the same case format as what is specified in the datafile setting
Email content from one customer: “One thing I noticed is that when you specify the file to create, (datafile=”C:\EXAMPLE.txt”) it will always create the filename in lowercase, example.txt. Could I make a suggestion for future updates so that the filename keeps the same case ... Read more
OraCmd Update: provide the current timestamp in the export filename
Use like this: datafile=”e:\temp\tables\jobs_#yyyy##mm##dd#-#hh##mi##ss#.txt”, will create file like, “jobs_20120410-010203.txt”. Updated program: http://www.withdata.com/down/OraCmd.exe . Web page: http://www.withdata.com/oracmd.html . ... Read more
Import data to Oracle
OraCmd is a command-line tools that can run sql command, import/export data, even without Oracle client. OraCmd takes the pain out of manual importing/exporting tasks, and avoids installing the Oracle client. Convenient, powerful Import Oracle data from file(csv, txt). Import Oracle data to ... Read more
Export Oracle data
OraCmd is the fast and easy command-line tool to import/export data, even without Oracle client. OraCmd takes the pain out of manual importing/exporting tasks, and avoids installing the Oracle client. Convenient, powerful Export from both table and query. Export all tables data in a schema to ... Read more
Alternative for SQL*Loader
OraCmd is a command-line tools that can run sql command, import/export data, even without Oracle client. OraCmd takes the pain out of manual importing/exporting tasks, and avoids installing the Oracle client. Convert SQL*Loader control file to OraCmd command To use SQL*Loader you have to ... Read more