1

Is there a way to cast long datatype to varchar on Oracle?

table 1: enter image description here

table 2: enter image description here

Errors:

Try1 Try2

Example of data on table 1 (table 2 is the same but without 'GUID|' and it's a varchar):

enter image description here

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;
Djonathan Krause
  • 124
  • 3
  • 14

0 Answers0