By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,049 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

how to add/merge varchar2s(Strings) in PL/SQL

P: 2
hi guys I need some very basic advise.

I've looked in the web but I can't find the information anywhere, but I am sure that it must be an easy task.

lets suppose i have three varchchar2

Expand|Select|Wrap|Line Numbers
  1. num Number := 2;
  2.  
  3. a varchar2 :='how do I ';
  4. b varchar2 := toChar(num);
  5. c varchar2 :' that';
  6.  
I need a third string

Expand|Select|Wrap|Line Numbers
  1. d varChar = ' how do I 2 that';
I think the conversion from string to char works quite find but how can I add char an varchar into one varchar in Java I would simply write d = a+b+c;

many thanks in advance

matthias
Apr 4 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 700
hi guys I need some very basic advise.

I've looked in the web but I can't find the information anywhere, but I am sure that it must be an easy task.

lets suppose i have three varchchar2

num Number := 2;

a varchar2 :='how do I ';
b varchar2 := toChar(num);
c varchar2 :' that';

I need a third string

d varChar = ' how do I 2 that';

I think the conversion from string to char works quite find but how can I add char an varchar into one varchar in Java I would simply write d = a+b+c;

many thanks in advance

matthias
Expand|Select|Wrap|Line Numbers
  1. For concatenation use || like that
  2. d:=a || b || c
  3.  
Apr 4 '08 #2

P: 2
Thank you very much for your quick response, of course it works like that.


have a nice day!
Apr 4 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.