How to Escape Percent Character (%) in Windows Batch Script

How to Escape Percent Character (%) in Windows Batch Script

milly 10:06 am on June 16, 2010 | Answers: 1
Tags: batch (12), character (8), command (38), oracle (136), percent, script (26), windows (150)

Rate Knowledge:

Loading ...

How to escape percent character (%) in Windows batch script

Follow this tip if you need to use the the actual percept character in batch script instead of using it as variable symbol. This is useful in using batch script to execute Oracle data pump command, which also utilize % sign.
- milly 10:06 am on June 16, 2010
  Example: Use % to display variable.
```
set ID=12345
echo %ID%
-- output would be 12345
```
  2. Use % in Oracle data pump command. You use three % characters to escape:
```
set ORACLE_SID=PRD
set PWD=manager
set TIMESTAMP=%date:~-4%%date:~4,2%%date:~7,2%

expdp system/%PWD%@ccbprd schemas=appuser DIRECTORY=dpump_dir1 JOB_NAME=hr LOGFILE=appuser_prd_expdp_%TIMESTAMP%.log DUMPFILE=appuser_prd_dp_%TIMESTAMP%_%%%u.dmp PARALLEL=4
```
Share this Knowledge
Submit Click here to cancel reply.

Log in to answer.