For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Isn't this exactly what you told the pivot table to do?
The two records can't be distinguished with the given values of startdate, hat and sipno.
You can add the starttime to the row edge and you should see the two rows.
Timo
Main problem here is i misunderstood pivot table's work principles. Thank you.