Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 39 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 17 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Delete record from Custom Table
Hi All,
we are using a custom table "MKT_REF_ENTITIES" to store data as a part of journal import and we have came across a occurrence where we need to delete few records from the above table can you suggest us the possible way to achieve that?
Thanks
Best Answer
-
Hi @User_EBVBI,
It depends on the specifics and circumstances of the scenario but since this is a custom table, its in a custom schema so you have control over it and you can manually delete the records.
If you also need to delete it from the data source, you may just want to delete it there first and allow your Pipeline to reconcile the difference.
Regards,
John
0
Answers
-
you can query from custom table :
select Id as "Id", RECORD_Name as "RecordName"
FROM svc_ref_entities sre
WHERE sre.attribute_category = 'XX_EBS_STOCK_DTL_c'then create csv file to import (Tools → Import Management )
here's sample csv file :
Id,RecordName
100000679953191,SCM_RECORD_190