Re: FOLD_AFTER on ORACLE 7

From: Christopher Jones <cjones_at_au.oracle.com>
Date: 16 Aug 1994 23:54:40 GMT
Message-ID: <CJONES.94Aug17095440_at_hurrah.au.oracle.com>

In article <32qe0n$b4u_at_pheidippides.axion.bt.co.uk> nkitchen_at_axion.bt.co.uk (Nicholas Kitchener) writes:

> Is there anthing wrong with the FOLD_AFTER command when it is used after
> a DATE datatype: ie
>
> COLUMN column_name1 FOLD_AFTER
> COLUMN column_name2 FOLD_AFTER
> COLUMN column_name3 FOLD_AFTER
>
> where the columns 1&2 are of type DATE and column 3 is of type number.
> In the SELECT I use to_char(column_date1,'DD/MM/YY HH24:MI:SS') - also for
> column2.
>
> However the output is:
>
> DD/MM/YY HH24:MI:SS ..<space padding>.. DD/MM/YY HH24:MI:SS ..<more sp. padding>... number <endofline>

Did you use column aliases correctly?

  column cn1 fold_after
  column cn2 fold_after
  column cn3 fold_after

  select  to_char(hiredate, 'DD/MM/YY HH24:MI:SS') cn1,
          to_char(hiredate, 'DD/MM/YY HH24:MI:SS') cn2,
          sal cn3

  from emp
  where deptno = 10;

Produces:

  CN1

---

  CN2

---

         CN3

---

  09/06/81 00:00:00
  09/06/81 00:00:00

        2450

  17/11/81 00:00:00
  17/11/81 00:00:00

        5000

  23/01/82 00:00:00
  23/01/82 00:00:00

        1300

If you don't want the blank line between records, set RECSEP off.

Chris Received on Wed Aug 17 1994 - 01:54:40 CEST