Oracle XML Publisher + How to display the numbers start with zero in Excel?

If our value is 01234 but in excel it shows 1234 because it converts it into number.

I have item number 006454.123. it is a varchar2 column. when I load it in xml and in output excel it is showing 6454.123

so to display as it is i used below code in form field.

<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">  <?ITEM_NUMBER?></fo:bidi-override>

Your's

Amar ALam

How to display column values in a row in oracle?

 SELECT

   deptno,

   RTRIM(xmlagg (xmlelement (e, ename || ',')).extract ('//text()'), ',') enames

FROM emp

GROUP BY deptno;

Your's

Amar Alam

Oracle Apps + How to get year start date and end date based on period name?

SELECT 
year_start_date,last_day(add_months(trunc(year_start_date,'YYYY') , 14)) year_end_date
FROM gl_periods
WHERE period_name='MAY-13';

YEAR_START_DATE YEAR_END_DATE
-----------------------------------
01-APR-13 31-MAR-14

Regards,

Amar

Oracle apps + How to display Sequence number in xml publisher?

Place the below code in a form field and place that form field after loop.

<?position()?>

It will display the numbers start from one.

Regards,

Amar

Oracle + Check Materialized View last refresh date and Time

SELECT

owner,

mview_name,

TO_CHAR(last_refresh_date, 'yyyymmddhh24miss') last_refresh_date

FROM all_mviews

WHERE 1=1

AND owner = 'APPS'

AND mview_name = 'XXVFI_SFDC_BOM_HDR_MV'

Regards,

Amar