How to Sort Data in the XMLP?

Oracle Apps Interview Questions › Category: XML Publisher › How to Sort Data in the XMLP?

Questions Master asked 4 years ago

1 Answers

Shailender Thallam Staff answered 4 years ago

Syntax:-

Case 1:-
<?sort:Field_Name?><?Field_Name?>
It sorts the data in Ascending order by Default.if Order By is not mentioned

Case 2:-
<?sort:Field_Name;’Order by‘?>
It sorts the data based on Order By mentioned here like Ascending Or Descending

Case 3:-
<?sort:Field_Name;’Order by‘;data-type=’text’?>
It sorts the String Data based on Order By mentioned here like Ascending Or Descending

Examples:-

Case 1:-
<?for-each:EMP_DETAILS?>
<?sort:EMP_NO?><?EMP_NAME?><?end for-each?>

Case 2:-
<?for-each:EMP_DETAILS?>
<?sort:EMP_NO;’descending‘?><?EMP_NAME?><?end for-each?>

Case 3:-
<?for-each:EMP_DETAILS?>
<?sort:EMP_NAME;’ascending‘;data-type=’text’?><?EMP_NAME?><?end for-each?>