Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert NCHAR to Hex when using XMLElement

Anuj GargFeb 2 2022

Hello All,
Test :

CREATE OR REPLACE TYPE DTOBJECT AS OBJECT
( 
  project_no NUMBER(2),
  datecol DATE,
  ncharcol nchar(50),
  nvarchar2col nvarchar2(50)
);

CREATE OR REPLACE TYPE vDTOBJECT AS VARRAY(500) OF DTOBJECT;
CREATE TABLE qatest.varray_datetime (id int, vdate vDTOBJECT);
INSERT INTO qatest.varray_datetime VALUES (1, vDTOBJECT( DTOBJECT(1, 
	to_date('2020-06-08', 'yyyy-mm-dd'), 'nchar', 'nvarcharcol')
	))

SQLPlus Output

SQL> SELECT id, XMLElement("vdate", vdate) FROM qatest.varray_datetime;


	ID
----------
XMLELEMENT("VDATE",VDATE)
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
	 1
<vdate><VDTOBJECT><DTOBJECT><PROJECT_NO>1</PROJECT_NO><DATECOL>2020-06-08T00:00:00.000000000</DATECOL><NCHARCOL>nchar						  </NCHARCOL><NVARCHAR2COL>nvarcharcol</
NVARCHAR2COL></DTOBJECT></VDTOBJECT></vdate>

SQL>

Question : How can I convert "ncharcol" and "nvarchar2col" values into Hexadecimal ?

Comments
Post Details
Added on Feb 2 2022
7 comments
363 views