Dear Experts,
Please help to update latest sms record in reg_tb
CREATE TABLE REG_TB
(
R_MOBILENO VARCHAR2(15),
R_REGNAME VARCHAR2(1000),
R_IMEI_NO VARCHAR2(80 BYTE)
);
INSERT INTO REG_TB VALUES('+85414756896','JOHN',NULL);
INSERT INTO REG_TB VALUES('+85854712534','JACOB',NULL);
CREATE TABLE SMS_TB
(
MOBILE_NO VARCHAR2(15 BYTE),
SMS_MSG VARCHAR2(4000 BYTE),
SMS_DATE_TIME VARCHAR2(20 BYTE),
IMEI_NO VARCHAR2(80 BYTE)
);
Sorry here we are storing date in varchar2,it should be changed to timestamp
INSERT INTO SMS_TB VALUES('+85414756896','BE','16/07/2019 10:06:01','150038347fd431b8e01610366252508');
INSERT INTO SMS_TB VALUES('+85414756896','BE','11/05/2020 17:27:09','160038347fd431b8e01610366252371');
INSERT INTO SMS_TB VALUES('+85414756896','BE','16/01/2021 10:06:01','865238347fd431b8e01610366252554');
INSERT INTO SMS_TB VALUES('+85854712534','BE','26/08/2020 13:51:26','27b6ebbd0ae93dce1598430109606');
INSERT INTO SMS_TB VALUES('+85854712534','BE','23/09/2020 13:35:05','8568b6ebbd0ae93dce1598430109');
INSERT INTO SMS_TB VALUES('+85854712534','BE','02/12/2020 12:11:36','7563ebbd0ae93dce159843047');
Expected result
select * from reg_tb;
R_MOBILENO R_REGNAME R_IMEI_NO
+85414756896 JOHN 865238347fd431b8e01610366252554 --- Latest Imei
+85854712534 JACOB 7563ebbd0ae93dce159843047 ----Latest Imei
Please help