OraCmd - Oracle access without client tool »
OraCmd FAQ
If you have any question, contact us:
- How can I get the load(unload) quote char to be a double quote (") ?
- How can I hide the password when I logon to Oracle ?
- How can I specify the record delimiter for unloading data ?
- How to connect as sysdba?
- How to set "NULLIF" value to empty string ?
- How to convert a SQL*Loader control file to OraCmd command ?
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:
see also: Connect to Oracle
3. How can I specify the record delimiter for unloading data ?
Set the parameter "recorddelimiter", default is CRLF .
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 .