Withdata Software

Category: OraCmd

  • How to call Oracle Stored Procedure in OraCmd

    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 can enter “call test_procedure();” to execute it. OraCmd> call test_procedure();   You…

  • 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 Better Client Tool For Oracle OraCmd is convenient:…

  • 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 format as what is specified in the datafile setting (datafile=”C:\EXAMPLE.txt”)” So…

  • 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 .

  • 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 other schema. Import Oracle CLOB data. Replace SQL*Loader. Custom import date format.…

  • 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 files in same time. Export Oracle CLOB data. Custom…

  • 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 install Oracle client software. To avoid installing the large client,…