Is there a way to cast long datatype to varchar on Oracle?
Errors:
Example of data on table 1 (table 2 is the same but without 'GUID|' and it's a varchar):
Obs.:
- I can not create another table (create as select);
- I've tried use pl/sql to select long into varchar (didn't work);
- to_char doesn't work;
- I have to update lines on table 1 that are in table 2;