Does Teradata supports generation of XML as query output like SQL Server. SQL Server has the FOR XML EXPLICIT construct which facilitate generation of XML as query output. The XML can hierarchy level depth of n. For e.g. Suppose we have two tables Employee and Department Employee(EmpID,Name) Department(DeptId,DeptName) Can I generate a XML
Can we generate a similar XML in Teradata, this is possible in SQL Server.