Long to Varchar2

Question

can you create a query that convert Long datatype to varchar2 datatype?

Answer 1

you dont need a query. just enclose the value in single quotes and Oracle will consider it as a varchar/string.
in Plsql, assign long value to varchar variable to do automatic conversion