is `CAST` not supported?
# suiteqlj
jen
07/29/2021, 9:48 PMis
CASTt
tdietrich
07/29/2021, 10:23 PM@jen It doesn't look like it.
SELECT CAST( '123' AS VARCHAR2 ) AS XXX FROM DUALj
jen
07/29/2021, 10:48 PMblech
jen
07/29/2021, 10:48 PMdamn you SQL-92
t
tdietrich
07/29/2021, 10:50 PMFrustrating, right? All that power that we can't make use of.
m
michoel
07/29/2021, 11:41 PMWould
BUILTIN_RESULTmichoel
07/29/2021, 11:42 PMt
tdietrich
07/30/2021, 2:55 PM@jen I know that you were wanting to CAST a value, but could using
TO_NCHARj
jen
07/30/2021, 3:42 PMZOMG it works
jen
07/30/2021, 3:42 PMthank you @tdietrich! I own you a 🍻
7 Views