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)
JRE 1.8.0_171/172 Certified with Oracle EBS 12.1 and 12.2 - Java Runtime Environment 1.8.0_171 (a.k.a. JRE 8u171-b11) and JRE 1.8.0_172 (a.k.a. JRE 8u172-b11) and later updates on the JRE 8 codeline are now certifie...
Acum 16 ore