CodePudding user response:

The select xmltype (colName) extract ('//nodeName/text () '). The getstringval () from the table, don't know the building Lord solved?