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!
I would like to show the SQL of current item's LOV record group, but seems that there is no such built-in like "GET_RECORD_GROUP_PROPERTY", any other way to get the SQL text of it ?
Merge updates/deletes matching rows and/or inserts non-matching rows. When matched means we took source row (source is defined by USING clause) and found a matching row in target (defined by INTO clause). In such case we can update/delete target row but not insert like in your example. When not matched means we took source row (source is defined by USING clause) but didn't find a matching row in target (defined by INTO clause). So what's here to delete from target? SY.
thank you for your clarity