If you want to count something inside a group (something the same as auto_increment from mysql), you can use row_number
OVER (PARTITION BY ur_prnt_uid_id ORDER BY ur_chld_uid_id)
Webcast: Testing Oracle E-Business Suite Best Practices - Oracle University has a large collection of free recorded webcasts that EBS system administrations may find useful. Here's a great webcast on testing E-Bu...
Acum 20 de ore