SQL> select TO_CHAR(SysDate,'DD/Mon/YYYY HH:MI P.M.') from dual;
TO_CHAR(SYSDATE,'DD/MO
----------------------
02/Mai  /2007 06:41 PM

1 row selected.

select name|| satus|| starttime 
from tab1,tab2 
where tab1nr= tab2nr
and status > 20 
orderby name;
/         --> so, do you have it in your real script?

First example 
NAME           STATUS                STARTTIME 


JOHN           SYSTEMNOTWORKED       2007-01-01-1.10.10


JOHNATHAN            SYSTEMNOTWORKED         2007-01-01-1.10.10


KRIM           SYSTEMNOTWORKED        2007-01-01-1.10.10




i want report should be like this in excel 

2nd example 

NAME              STATUS                 STARTTIME 


JOHN              SYSTEMNOTWORKED        2007-01-01-1.10.10


JOHNATHAN         SYSTEMNOTWORKED        2007-01-01-1.10.10


KRIM              SYSTEMNOTWORKED        2007-01-01-1.10.10


could you pl tell me why i am not getting fomatt correctly in exce[ALIGN=left][/ALIGN]l report. 

here is my code


spool /test/report.lst
set linesize 300
set pagesize 0
set feedback off
col name foramt a35
col status foramt a30
col starttime format a30
col endtime foramt a30 
col code foramat 999

select name,
decode(status,
'1100','forward'
'1200','backward'
'9999','none'),
startttime,
endtime,
code,
from tax_tab a, income_tab b 

where a.tax_tab.nbr = b.income_tab.nbr
and a.starttime > 0001
and a.endtime < 2359
and b.code > 4
orderby a.starttime;
spool off
exit

SET LINESIZE 300
SET PAGESIZE 50
SET FEEDBACK OFF

COLUMN NAME HEADING 'NAME' FORMAT A35
COLUMN STATUS COL 40 HEADING ' STATUS ' FORMAT A30
COLUMN STARTTIME COL 72 HEADING ' START TIME ' FORMAT A30
COLUMN ENDTTIME COL 103 HEADING 'END TIME' FORMAT A35
COLUMN CODE COL200 HEADING 'CODE' FORAMT 999

This is my query

Select first_name "name",
DECODE(STATUS,
'9999','BACKWARD',
'8888','FORWARD',
'7777','TRANSFERING READY',
'6666','STOPPED - NOTWORKING STOPPED SYSTEM', 
'UNDEFINED')"STATUS",

to_char(new_time(table1_TimeStamp2,'gmt','edt'),'MM/DD/YY HH24:MI:SS')"STARTTIME",

to_char(new_time(table1_TimeStamp4,'gmt','edt'),'MM/DD/YY HH24:MI:SS')"ENDTTIME"

from table1,table2

where table1_idnr = table2_idnr

and 
table1_TimeStamp2 >= TO_DATE('2007-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS')
and 
table1_TimeStamp4 <= TO_DATE('2007-01-03 20:59:59','YYYY-MM-DD HH24:MI:SS')

and tabel2_Name like '%JOH%'
order by STARTTIME;
spool off

say for example i got 2 rows from sql query
1st row person name JOHNATHAN is no of chars are 9
2nd row person name JOHN is no of chars are 4


currently i am getting report like this in excel 
see 2nd col and 3rd col it is moving away because of name is long

NAME           STATUS                STARTTIME 


JOHN           SYSTEMNOTWORKED       2007-01-01-1.10.10


JOHNATHAN            SYSTEMNOTWORKED         2007-01-01-1.10.10


KRIM           SYSTEMNOTWORKED        2007-01-01-1.10.10




i want report like this in excel 



NAME              STATUS                 STARTTIME 


JOHN              SYSTEMNOTWORKED        2007-01-01-1.10.10


JOHNATHAN         SYSTEMNOTWORKED        2007-01-01-1.10.10


KRIM              SYSTEMNOTWORKED        2007-01-01-1.10.10

Select first_name ||','||
DECODE(STATUS,
'9999','BACKWARD',
'8888','FORWARD',
'7777','TRANSFERING READY',
'6666','STOPPED - NOTWORKING STOPPED SYSTEM', 
'UNDEFINED')||','||

to_char(new_time(table1_TimeStamp2,'gmt','edt'),'MM/DD/YY HH24:MI:SS')||','||

to_char(new_time(table1_TimeStamp4,'gmt','edt'),'MM/DD/YY HH24:MI:SS')

from table1,table2

where table1_idnr = table2_idnr

and 
table1_TimeStamp2 >= TO_DATE('2007-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS')
and 
table1_TimeStamp4 <= TO_DATE('2007-01-03 20:59:59','YYYY-MM-DD HH24:MI:SS')

and tabel2_Name like '%JOH%'
order by STARTTIME;
spool off

Select first_name "name",
DECODE(STATUS,
'9999','BACKWARD',
'8888','FORWARD',
'7777','TRANSFERING READY',
'6666','STOPPED - NOTWORKING STOPPED SYSTEM', 
'UNDEFINED')"STATUS",

to_char(new_time(table1_TimeStamp2,'gmt','edt'),'MM/DD/YY HH24:MI:SS')"STARTTIME",

to_char(new_time(table1_TimeStamp4,'gmt','edt'),'MM/DD/YY HH24:MI:SS')"ENDTTIME"

from table1,table2

where table1_idnr = table2_idnr

and 
table1_TimeStamp2 >= TO_DATE('2007-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS')
and 
table1_TimeStamp4 <= TO_DATE('2007-01-03 20:59:59','YYYY-MM-DD HH24:MI:SS')

and tabel2_Name like '%JOH%'
order by STARTTIME;
spool off

say for example i got 2 rows from sql query
1st row person name JOHNATHAN is no of chars are 9
2nd row person name JOHN is no of chars are 4


currently i am getting report like this in excel 
see 2nd col and 3rd col it is moving away because of name is long

NAME           STATUS                STARTTIME 


JOHN           SYSTEMNOTWORKED       2007-01-01-1.10.10


JOHNATHAN            SYSTEMNOTWORKED         2007-01-01-1.10.10


KRIM           SYSTEMNOTWORKED        2007-01-01-1.10.10




i want report like this in excel 



NAME              STATUS                 STARTTIME 


JOHN              SYSTEMNOTWORKED        2007-01-01-1.10.10


JOHNATHAN         SYSTEMNOTWORKED        2007-01-01-1.10.10


KRIM              SYSTEMNOTWORKED        2007-01-01-1.10.10

ABCD.MNOPQQRSZPKDBHMD,ENDED_OK,05/01/07 20:27:32,05/01/07 21:27:31,+00:59:59,0
ANDJDKD,EELD.DLDLD,DKD,ENDED_OK,05/01/07 21:00:22,05/01/07 21:37:31,+00 00:37:09,0
HSYSHSJSKSKSKSKSKSKSD,ENDED_OK,05/01/07 21:27:31,05/01/07 21:28:24,+00 00:00:53,0
DJDHDHDHDHDHDHDHDHDHD,ENDED_OK,05/01/07 21:28:24,05/01/07 21:28:29,+00 00:00:05,0
JSJSJSJSJSJSJSJSJSJSD,ENDED_OK,05/01/07 21:28:46,05/01/07 21:44:41,+00 00:15:55,0
SKSKSKSKSKSKSKSKSKSKS,ENDED_OK,05/01/07 21:37:32,05/01/07 22:00:36,+00 00:23:04,0

create or replace
package owa_sylk as
--
  type owaSylkArray is table of varchar2(2000);
--
  procedure show(
      p_file          in utl_file.file_type,
      p_query         in varchar2,
      p_parm_names    in owaSylkArray default owaSylkArray(),
      p_parm_values   in owaSylkArray default owaSylkArray(),
      p_sum_column    in owaSylkArray default owaSylkArray(),
      p_max_rows      in number     default 10000,
      p_show_null_as  in varchar2   default null,
      p_show_grid     in varchar2   default 'YES',
      p_show_col_headers in varchar2 default 'YES',
      p_font_name     in varchar2   default 'Courier New',
      p_widths        in owaSylkArray default owaSylkArray(),
      p_titles        in owaSylkArray default owaSylkArray(),
      p_formats       in owaSylkArray default owaSylkArray(),
      p_types         in owaSylkArray default owaSylkArray(),
      p_strip_html    in varchar2   default 'YES' );
--
  procedure show(
      p_file          in utl_file.file_type,
      p_cursor        in integer,
      p_sum_column    in owaSylkArray  default owaSylkArray(),
      p_max_rows      in number     default 10000,
      p_show_null_as  in varchar2   default null,
      p_show_grid     in varchar2   default 'YES',
      p_show_col_headers in varchar2 default 'YES',
      p_font_name     in varchar2   default 'Courier New',
      p_widths        in owaSylkArray default owaSylkArray(),
      p_titles        in owaSylkArray default owaSylkArray(),
      p_formats       in owaSylkArray default owaSylkArray(),
      p_types         in owaSylkArray default owaSylkArray(),
      p_strip_html    in varchar2   default 'YES' );
--
end owa_sylk;
/

create or replace
package body owa_sylk as
--
  g_cvalue  varchar2(32767);
  g_desc_t dbms_sql.desc_tab;

  type vc_arr is table of varchar2(2000) index by binary_integer;
  g_lengths vc_arr;
  g_sums vc_arr;
--
--

  g_file  utl_file.file_type;


  procedure p( p_str in varchar2 )
  is
  begin
    utl_file.put_line( g_file, p_str );
  exception
    when others then null;
  end;

  function build_cursor(
      q in varchar2,
      n in owaSylkArray,
      v in owaSylkArray ) return integer is
    c integer := dbms_sql.open_cursor;
    i number := 1;
  begin
    dbms_sql.parse (c, q, 1);
    loop
      dbms_sql.bind_variable( c, n(i), v(i) );
      i := i + 1;
    end loop;
    return c;
  exception
    when others then
      return c;
  end build_cursor;
--
--
  function str_html ( line in varchar2 ) return varchar2 is
    x       varchar2(32767) := null;
    in_html boolean         := FALSE;
    s       varchar2(1);
  begin
    if line is null then
      return line;
    end if;
    for i in 1 .. length( line ) loop
      s := substr( line, i, 1 );
      if in_html then
        if s = '>' then
          in_html := FALSE;
        end if;
      else
        if s = '<' then
          in_html := TRUE;
        end if;
      end if;
      if not in_html and s != '>' then
        x := x || s;
      end if;
    end loop;
    return x;
  end str_html;
--
  function ite( b boolean,
                t varchar2,
                f varchar2 ) return varchar2 is
  begin
    if b then
      return t;
    else
      return f;
    end if;
  end ite;
--
  procedure print_comment( p_comment varchar2 ) is
  begin
    return;
    p( ';' || chr(10) || '; ' || p_comment || chr(10) || ';' );
  end print_comment;
--
  procedure print_heading( font in varchar2, 
                           grid in varchar2, 
                           col_heading in varchar2, 
                           titles in owaSylkArray,
                           formats in owaSylkArray,
                           types in owaSylkArray ) 
  is
    l_title varchar2(2000);
    l_format varchar2(2000);
    l_type   varchar2(2000);
    datepic  varchar2(10);
  begin
    p( 'ID;ORACLE' );
    -- Put in a default format for date in case it is needed
    p( 'P;Pm/d/yyyy' );
    print_comment( 'Fonts' );
    p( 'P;F' || font || ';M200' );
    p( 'P;F' || font || ';M200;SB' );
    p( 'P;F' || font || ';M200;SUB' );
    --
    print_comment( 'Global Formatting' );
    p( 'F;C1;FG0R;SM1' || 
           ite( upper(grid)='YES', '', ';G' ) || 
           ite( upper(col_heading)='YES', '', ';H' )  );
    for i in 1 .. g_desc_t.count loop
      begin
        l_format := formats(i);
      exception
        when others then
          l_format := 'GOR';
      end;
      begin
        l_type := types(i);
      exception
        when others then
          l_type := 'T';
      end;
      -- Set the date format if type id D
      if l_type = 'D' then
        datepic := ';P0';
      else
        datepic := null;
      end if;

      p( 'F;C' || to_char(i+1) || datepic || ';F' || l_format || ';SM0' );
    end loop;
    --
    print_comment( 'Title Row' );
    p( 'F;R1;FG0C;SM2' );
    for i in 1 .. g_desc_t.count loop
      g_lengths(i) := g_desc_t(i).col_name_len;
      g_sums(i) := 0;
      begin
        l_title := titles(i);
      exception
        when others then
          l_title := g_desc_t(i).col_name;
      end;
      if i = 1 then
        p( 'C;Y1;X2;K"' || l_title || '"' );
      else
        p( 'C;X' || to_char(i+1) || ';K"' || l_title || '"' );
      end if;
    end loop;
  end print_heading;
--
  function print_rows(
      c            in integer,
      max_rows     in number,
      sum_columns  in owaSylkArray,
      show_null_as in varchar2,
      strip_html   in varchar2,
      types        in owaSylkArray ) return number is
    row_cnt number          := 0;
    line      varchar2(32767) := null;
    n         number;
    l_type    varchar2(2000);
    delimiter varchar2(1);
  begin
    loop
      exit when ( (max_rows <> 0 and row_cnt >= max_rows) or
                  dbms_sql.fetch_rows( c ) <= 0 );
      row_cnt := row_cnt + 1;
      print_comment( 'Row ' || row_cnt );
      --
      p( 'C;Y' || to_char(row_cnt+2) );

      for i in 1 .. g_desc_t.count loop
        begin
          l_type := types(i);
        exception
          when others then
            l_type := 'T';
        end;
        if l_type in ('N','D') then
          delimiter := null;
        else
          delimiter := '"';
        end if;
        dbms_sql.column_value( c, i, g_cvalue );
        g_cvalue := translate( g_cvalue, 
                            chr(10)||chr(9)||';', '   ' );
        g_cvalue := ite( upper( strip_html ) = 'YES',
                             str_html( g_cvalue ),
                             g_cvalue );
        g_lengths(i) := greatest( nvl(length(g_cvalue), 
                                  nvl(length(show_null_as),0)),
                                  g_lengths(i) );
        line := 'C;X' || to_char(i+1);
        line := line || ';K';
        begin
          n := to_number( g_cvalue );
          if upper( sum_columns(i)) = 'Y' then
            g_sums(i) := g_sums(i) + nvl(n,0);
          end if;
        exception
          when others then
            n := null;
        end;
        line := line || 
                 ite( n is null, 
                      ite( g_cvalue is null, 
                               '"'||show_null_as||
                                  '"', delimiter||g_cvalue||delimiter ), 
                             n );
        p( line );
      end loop;
      --
    end loop;
    return row_cnt;
  end print_rows;
--
  procedure print_sums(
      sum_columns  in owaSylkArray,
      row_cnt      in number ) is
  begin
    if sum_columns.count = 0 then
      return;
    end if;
    --
    print_comment( 'Totals Row' );
    p( 'C;Y' || to_char(row_cnt + 4) );
    p( 'C;X1;K"Totals:"' );
    --
    for i in 1 .. g_desc_t.count loop
      begin
        if upper(sum_columns(i)) = 'Y' then
          p( 'C;X' || to_char(i+1) || ';ESUM(R3C:R' || 
                  to_char(row_cnt+2) || 'C)' );
        end if;
      exception
        when others then
          null;
      end;
    end loop;
  end print_sums;
--
  procedure print_widths( widths owaSylkArray ) is
  begin
    print_comment( 'Format Column Widths' );
    p( 'F;W1 1 7' );
    for i in 1 .. g_desc_t.count loop
      begin
        p( 'F;W' || to_char(i+1) || ' ' || 
            to_char(i+1) || ' ' || 
            to_char(to_number(widths(i))) );
      exception
        when others then
          p( 'F;W' || to_char(i+1) || ' ' || 
               to_char(i+1) || ' ' || 
               greatest( g_lengths(i), length( g_sums(i) )));
      end;
    end loop;
    p( 'E' );
  end print_widths;
--
  procedure show(
      p_file          in utl_file.file_type,
      p_cursor        in integer,
      p_sum_column    in owaSylkArray default owaSylkArray(),
      p_max_rows      in number     default 10000,
      p_show_null_as  in varchar2   default null,
      p_show_grid     in varchar2   default 'YES',
      p_show_col_headers in varchar2 default 'YES',
      p_font_name     in varchar2   default 'Courier New',
      p_widths        in owaSylkArray default owaSylkArray(),
      p_titles        in owaSylkArray default owaSylkArray(),
      p_formats       in owaSylkArray default owaSylkArray(),
      p_types         in owaSylkArray default owaSylkArray(),
      p_strip_html    in varchar2   default 'YES' ) is
  --
    l_row_cnt number;
    l_col_cnt number;
    l_status  number;
  begin
    g_file := p_file;
    dbms_sql.describe_columns( p_cursor, l_col_cnt, g_desc_t );
    --
    for i in 1 .. g_desc_t.count loop
      dbms_sql.define_column( p_cursor, i, g_cvalue, 32765);
    end loop;
    --
    print_heading( p_font_name, 
                   p_show_grid, 
                   p_show_col_headers, 
                   p_titles,
                   p_formats,
                   p_types );
    l_status := dbms_sql.execute( p_cursor );
    l_row_cnt := print_rows(
                   p_cursor, 
                   p_max_rows,
                   p_sum_column,
                   p_show_null_as,
                   p_strip_html,
                   p_types );
    print_sums( p_sum_column, l_row_cnt );
    print_widths( p_widths );
  end show;
--
  procedure show(
      p_file          in utl_file.file_type,
      p_query         in varchar2,
      p_parm_names    in owaSylkArray default owaSylkArray(),
      p_parm_values   in owaSylkArray default owaSylkArray(),
      p_sum_column    in owaSylkArray default owaSylkArray(),
      p_max_rows      in number     default 10000,
      p_show_null_as  in varchar2   default null,
      p_show_grid     in varchar2   default 'YES',
      p_show_col_headers in varchar2 default 'YES',
      p_font_name     in varchar2   default 'Courier New',
      p_widths        in owaSylkArray default owaSylkArray(),
      p_titles        in owaSylkArray default owaSylkArray(),
      p_formats       in owaSylkArray default owaSylkArray(),
      p_types         in owaSylkArray default owaSylkArray(),
      p_strip_html    in varchar2   default 'YES' ) is
  begin
    show( p_file => p_file,
          p_cursor => build_cursor( p_query, 
                                    p_parm_names, 
                                    p_parm_values ),
          p_sum_column => p_sum_column,
          p_max_rows => p_max_rows,
          p_show_null_as => p_show_null_as,
          p_show_grid => p_show_grid,
          p_show_col_headers => p_show_col_headers,
          p_font_name => p_font_name,
          p_widths => p_widths,
          p_titles => p_titles,
          p_formats => p_formats,
          p_types => p_types,
          p_strip_html => p_strip_html );
  end show;
--
end owa_sylk;
/