How to create an Oracle SQL query that update a part of a string with value of another column?
I have 2 tables, CONTENT Table and CONTENT_DETAIL Table, in my CONTENT Table it has contentId & articleId columns, in CONTENT_DETAIL Table, it has contentId & content(BLOB) columns. i want to update content column in CONTENT_DETAIL table that the content column contains string in pattern ABC_123456 (6 random digits with ABC_ prefix, the 6 digits will match with the articleId in CONTENT Table) and replace the ABC_123456 with contentId in CONTENT table, how can i do?
How to create an Oracle SQL that update a part of a string with value of another column?
I have 2 tables, CONTENT Table and CONTENT_DETAIL Table, in my CONTENT Table it has contentId & articleId columns, in CONTENT_DETAIL Table, it has contentId & content(BLOB) columns. i want to update content column in CONTENT_DETAIL table that the content column contains string in pattern ABC_123456 (6 random digits with ABC_ prefix, the 6 digits will match with the articleId in CONTENT Table) and replace the ABC_123456 with contentId in CONTENT table, how can i do?