OraCmd - Oracle access without client tool »

Download OraCmd Free Trial »

OraCmd FAQ

If you have any question, contact us:

1. How can I get the load(unload) quote char to be a double quote (") ?

Set parameter "quote=chr(34)" .

2. How can I hide the password when I logon to Oracle (") ?

To hide password, use:

OraCmd > connect username@host:port:SID;

example:

Oracle Command Tool - Oracmd connect oracle

see also: Connect to Oracle

3. How can I specify the record delimiter for unloading data ?

Set the parameter "recorddelimiter", default is CRLF .

4. How to connect as sysdba ?

OraCmd > connect username/password@host:port:SID as sysdba;

see also: Connect to Oracle .

5. How to set "NULLIF" value to empty string ?

Set parameter "nullif=blanks" .

6. How to convert a SQL*Loader control file to OraCmd command ?

Read this: Convert SQL*Loader control file to OraCmd command .