The select xmlquery (' & lt; Manifest>
{for $vv ora: in the view (" vessel_visit ")/ROW where $v. v./ID="1 fb017a696a54f62b656481d975417c6"
Return
{$v. v./CREATED_BY} & lt;/RepresentativePerson>
}
'
Returning the content)
High_commission_emp_names
The from dual;
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Does anyone know how to add an alias to CREATED_BY field?

CodePudding user response: