Unanswered: SQL Help: ---conversion from number to varchar2.
Hello experts, I am doing some data migration and need some help.
Here is the table structure..
( ID NUMBER, LIST NUMBER(10), MULTILIST VARCHAR2(255));
I want to move the values that are in LIST into MULTILIST columns.
Value in LIST column which is 12345 should look as ,12345, after migration (comma before and after the number). Can you please help validate the SQL..Here is what I have... Do I need to use any fuction to convert the num to varchar? I ran the below sql and it went through..Just want to make sure.
update page_two set multilist02=','||list08||',' where class=7000 and id=17436524;