[Wildhias]

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

[rski]

Originally Posted by Wildhias

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.  

[Wildhias]

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


have a nice day!