How to perform string concatenation in PL/SQL?

Question

I have a variable defined as

define dbs '&1'

Suppose I pass database1 as an argument. Then the statement is interpreted as

define dbs database1

I want to append single quotes around the string, ie I want it to be interpreted as

define dbs 'database1'

How should I do this?

Thilo · Accepted Answer · 2010-10-20 05:10:43Z

18

Single quotes in strings need to be escaped with another single quote, so you would write (if I understand macro expansion correctly)

 '''&1'''

String concatenation is done with the || operator

 '''' || '&1' || ''''

answered Oct 20, 2010 at 5:10

Thilo

264k107 gold badges527 silver badges674 bronze badges

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

1 Answer 1