Query with nulls when field value change

[AlexHarley666]

Hello my friends!!!!!!

My question: Why Can I obtain this result from any query?

Row iden_orden field1 field2...fieldn
--- ---------- ------ ------ ------
1 1234 value1 value2 value3
2
3 1235 valueA valueB valueC
4
5 1236 valueX valueY valueZ

Only separates with NULL's when iden_orden field changes...

Please, I need your help...!!!

Thanks in advance, ALEX

excuse me for my bad english language...!!!

 

[LKBrwnDBA]

In SQL*Plus try:

BREAK ON iden_orden SKIP 1 ON REPORT


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb