How to print with powershell from SQLplus a string with quotation quotes

Question

Sequel from this question

define a='eee"dd'
prompt &a                       -- eee"dd OK
host powershell.exe echo '&a';  -- eeedd  not OK
host powershell.exe echo &a;    -- eeedd  not OK

As you can see, I can't print a stirng with a quotation quote in powershell from sql plus. Is there a way to do that.?

I've tried the solution of Alex Poole when the value comes from a query.But it's not working if there is more than one quotation string.

column a new_value a 
select replace('eee"d"d', '"', '""') as a from dual;

prompt &a                      -- eee""d""d  Ok as expected
host powershell.exe echo '"&a"'-- eee"dd instead of eee"d"d

Alex Poole · Accepted Answer · 2022-06-07 08:31:07Z

1

It seems to work if you escape the quote (for PowerShell's benefit) by using "" within the value, and use both types of quotes, for both PowerShell's and SQL*Plus's benefit:

SQL> define a='eee""dd'
SQL> host powershell.exe echo '"&a"'
eee"dd

If you are actually populating the a variable from a query, as in your previous questions, then you can replace() quotes with:

column a new_value a
select replace('eee"dd', '"', '""') as a from dual;

answered Jun 7, 2022 at 8:31

Alex Poole

192k11 gold badges198 silver badges349 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Pierre-olivier Gendraud Over a year ago

thanks for your answer. I's not working if I use more than one quotation quote. I've given a exemple in my question.

Alex Poole Over a year ago

That seems to be a PowerShell issue... from the command line, one of their sample strings "As they say, ""live and learn.""" works, but not with anything between the 'real' closing quote and the string-ending quote, even a space, e.g. "As they say, ""live and learn."" ".

mklement0 Over a year ago

Without cmd.exe in the picture, the robust way to escape " chars. for the PowerShell CLI with the (possibly implied) -Command parameter is to use \". With cmd.exe in the picture, this may break situationally, and the workaround depends on the edition of PowerShell you use - see this answer.

Pierre-olivier Gendraud · Accepted Answer · 2022-06-07 09:31:59Z

1

column a new_value a
select replace('eee"d"d', '"', '\"') as a from dual;
host powershell.exe echo '&a'

works for me

answered Jun 7, 2022 at 9:31

Pierre-olivier Gendraud

2,0172 gold badges23 silver badges62 bronze badges

Collectives™ on Stack Overflow

How to print with powershell from SQLplus a string with quotation quotes

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related