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)
Upcoming FMW/WLS for EBS Webinar - OAUG AppsTech 2018 - The Oracle E-Business Suite Release 12.2 technology stack employs Oracle Fusion Middleware (FMW) 11g, including Oracle WebLogic Server (WLS). Join us for t...
Acum 2 zile