SELECT DBMS_XMLQUERY.getxml
          ('select deptno DepartmentId,dname DepartmentName ,loc LocationOfSpecifiedNecessaryDepartment from scott.dept'
          )
  FROM DUAL
  
  
output:
  
  <?xml version = '1.0'?>
<ERROR>oracle.xml.sql.OracleXMLSQLException: ORA-00972: identifier is too long
</ERROR>

SQL> SELECT DBMS_XMLQUERY.getxml
  2            ('select deptno DepartmentId,
  3                     dname DepartmentName,
  4                     loc LocationOfSpecifiedNecessaryDepartment 
  5              from scott.dept') res
  6  FROM DUAL
  7  /
RES
-----------------------------------------------------------------------------------------------
<?xml version = '1.0'?>
<ERROR>oracle.xml.sql.OracleXMLSQLException: ORA-00972: identifier is too long
</ERROR>

1 row selected.

SQL> SELECT replace(
  2         DBMS_XMLQUERY.getxml
  3     ('select deptno DepartmentId,
  4              dname DepartmentName,
  5              loc Location
  6       from scott.dept'),
  7     'LOCATION','LOCATIONOFSPEFICIEDNECESSARYDEPARTMENT') res
  8  FROM DUAL
  9  /
RES
-----------------------------------------------------------------------------------------------
<?xml version = '1.0'?>
<ROWSET>
   <ROW num="1">
      <DEPARTMENTID>10</DEPARTMENTID>
      <DEPARTMENTNAME>ACCOUNTING</DEPARTMENTNAME>
      <LOCATIONOFSPEFICIEDNECESSARYDEPARTMENT>NEW YORK</LOCATIONOFSPEFICIEDNECESSARYDEPARTMENT>
   </ROW>
   <ROW num="2">
      <DEPARTMENTID>20</DEPARTMENTID>
      <DEPARTMENTNAME>RESEARCH</DEPARTMENTNAME>
      <LOCATIONOFSPEFICIEDNECESSARYDEPARTMENT>DALLAS</LOCATIONOFSPEFICIEDNECESSARYDEPARTMENT>
   </ROW>
   <ROW num="3">
      <DEPARTMENTID>30</DEPARTMENTID>
      <DEPARTMENTNAME>SALES</DEPARTMENTNAME>
      <LOCATIONOFSPEFICIEDNECESSARYDEPARTMENT>CHICAGO</LOCATIONOFSPEFICIEDNECESSARYDEPARTMENT>
   </ROW>
   <ROW num="4">
      <DEPARTMENTID>40</DEPARTMENTID>
      <DEPARTMENTNAME>OPERATIONS</DEPARTMENTNAME>
      <LOCATIONOFSPEFICIEDNECESSARYDEPARTMENT>BOSTON</LOCATIONOFSPEFICIEDNECESSARYDEPARTMENT>
   </ROW>
</ROWSET>

1 row selected.