Long to Varchar2 | Sololearn: Learn to code for FREE!
Novo curso! Todo programador deveria aprender IA generativa!
Experimente uma aula grƔtis
+ 1

Long to Varchar2

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

28th Aug 2017, 9:36 AM
Sadegh
1 Resposta
0
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
27th Sep 2017, 12:36 PM
Gurpreet Singh
Gurpreet Singh - avatar