Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> simple PL/SQL syntax question.

simple PL/SQL syntax question.

From: Rich Davies <Richard_Davies_at_retek.com>
Date: 1997/12/22
Message-ID: <01bd0f02$0030eec0$af01010a@msppc060.retek.com>#1/1

Can someone explain why this works, please?

I want to set the value of one local string variable in PL/SQl to:  

    USER_ID = 'another_local_string'

including the single ticks. Through trial and error I've found the following assignment statement works.

a_local_string := 'USER_ID = ''' || another_local_string || '''' ;

In case this is hard to read with your typeface, that is: one single tick at the beginning, three single ticks in the middle, and four single ticks at the end.

Does this make sense to anyone? If so please enlighten me. Thanks in advance.

-- 
richard_davies_at_retek.com
Received on Mon Dec 22 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US