Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

START_POSITION specifies which character in the supplied string to start with, and the optional length specifies how many c

SQL> SQL> SELECT   2     DUMP('ABC',1010,1)  type_info   3  FROM dual; TYPE_INFO ------------------------------------------------ Typ=96 Len=3 CharacterSet=WE8MSWIN1252: 65,66,67