CODEWITHSUNDEEP
sqllinuxplsqlsqlplus
Lura Jeni Rajan
Lura Jeni Rajan

Reputation: 61

Folder name with space in SQL*Plus script

I wrote the following script to create a new folder 

column mn new_value _mn;
select '\\common\jds\Daily report\DailyReport2017\\'||tochar(sysdate,'mon')||'\';
host mkdir &_mn;

but it throws error

'The specified path is invalid.
Error occurred while processing \\common\jdfs\Daily',

since there is space in the name

How can I create the folder

Upvotes: 0

Views: 452

Answers (1)

xtoik
xtoik

Reputation: 676

Unlike in Windows, In Linux the default folder separator is the / and the spaces must be escaped with a backslash (\). Therefore I would try to use this instead:

select '/common/jds/Daily\ report/DailyReport2017/' || tochar(sysdate,'mon')  || '/';

Upvotes: 3

Related Questions