BREAK ON is not working

[jayjaybigs]

Hello All,

I am using a break on as follows:

BREAK ON TADFTN.CODE

select TADFTN.CODE,
TADFTN.DATA_VAL COLUMN_NAME,
(select COUNT(TADFA3.DATA_VAL)
from LOOKUP_TADFA3 TADFA3
where TADFA3.TN_KEY = TADFTN.CODE
group by TADFA3.TN_KEY) Number_Of_Values,
TADFA4.TN_KEY,
TADFA4.DATA_VAL,
TADFA4.CODE
from LOOKUP_TADFTN TADFTN,LOOKUP_DB2_TADFA3 TADFA4
where TADFTN.CODE = TADFA4.TN_KEY
order by 1

Here is my result:

CODE COLUMN_NAME
-------- -----------
VISATP IMGRTN_VS_TYP_CD
VISATP IMGRTN_VS_TYP_CD
VISATP IMGRTN_VS_TYP_CD
WHLTTR WHR_LTR_SNT_CD
WHLTTR WHR_LTR_SNT_CD
WTNGPD INTRNL_WTNG_PRD
WTNGPD INTRNL_WTNG_PRD

I was expecting:

CODE COLUMN_NAME
-------- -----------
VISATP IMGRTN_VS_TYP_CD
IMGRTN_VS_TYP_CD
IMGRTN_VS_TYP_CD
WHLTTR WHR_LTR_SNT_CD
WHR_LTR_SNT_CD
WTNGPD INTRNL_WTNG_PRD
INTRNL_WTNG_PRD

Please help

 

[Dagon]

This is an Oracle sql*plus feature (not SQL) and is therefore not suitable for an ANSI SQL forum.