Home -> Usenet -> comp.databases.oracle -> FOLD_AFTER on ORACLE 7

FOLD_AFTER on ORACLE 7

From: Nicholas Kitchener <nkitchen_at_axion.bt.co.uk>
Date: 16 Aug 1994 13:12:55 GMT
Message-ID: <32qe0n$b4u_at_pheidippides.axion.bt.co.uk> 






 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>



Not what would have expected!


I expect:

	DD/MM/YY HH24:MI:SS <end-of-line>
	DD/MM/YY HH24:MI:SS <end-of-line>
	number <end-of-line>





 Can anyone help (or is this an 'undocumented feature' of ORACLE) ?



 Thanks in advance,



        Nick.



    
  
  •   Reality is just an illusion, caused by the lack of VDU radiation (or alcohol)     --
  
  •   My views don't repesent BT, where Reality[1] and Illusion[2] are to be evaluated, --
  
  •   whilst alcohol[3] is to be studied in greater volume, sorry, depth.               --
 



Received on Tue Aug 16 1994 - 15:12:55 CEST












Original text of this message