Hi
when starting with the same sequence, display the item with the most characters
CREATE TABLE EXPORT_TABLE
(DT_ATUALIZACAO DATE NOT NULL,
DADOS VARCHAR2(4000 BYTE) NOT NULL
);
DROP TABLE EXPORT_TABLE
Insert into EXPORT_TABLE (DT_ATUALIZACAO,DADOS) values (to_date('16/04/21 18:00:00','DD/MM/RR HH24:MI:SS'),'10990350,10990352,10856224,10990348');
Insert into EXPORT_TABLE (DT_ATUALIZACAO,DADOS) values (to_date('16/04/21 18:00:00','DD/MM/RR HH24:MI:SS'),'10990350,10990352,10856224,10990348');
Insert into EXPORT_TABLE (DT_ATUALIZACAO,DADOS) values (to_date('19/04/21 18:00:00','DD/MM/RR HH24:MI:SS'),'10990350,10990352,10856224,10990348');
Insert into EXPORT_TABLE (DT_ATUALIZACAO,DADOS) values (to_date('12/04/21 18:00:00','DD/MM/RR HH24:MI:SS'),'10990063,10990235,10990065');
Insert into EXPORT_TABLE (DT_ATUALIZACAO,DADOS) values (to_date('19/04/21 18:00:00','DD/MM/RR HH24:MI:SS'),'10990249,10990250');
Insert into EXPORT_TABLE (DT_ATUALIZACAO,DADOS) values (to_date('25/04/21 18:00:00','DD/MM/RR HH24:MI:SS'),'10990249,10990250,10990251');
Insert into EXPORT_TABLE (DT_ATUALIZACAO,DADOS) values (to_date('25/04/21 18:00:00','DD/MM/RR HH24:MI:SS'),'10990249,10990250,10990251');
Insert into EXPORT_TABLE (DT_ATUALIZACAO,DADOS) values (to_date('16/04/21 18:00:00','DD/MM/RR HH24:MI:SS'),'10990254,10990256');
Insert into EXPORT_TABLE (DT_ATUALIZACAO,DADOS) values (to_date('14/04/21 18:00:00','DD/MM/RR HH24:MI:SS'),'10990063,10990235,10990065');
SELECT * FROM EXPORT_TABLE
RESULT
<img src="https://objectstorage.us-phoenix-1.oraclecloud.com/p/BqK85Rn1zA5MP0vYiqbAdPgs7Z6OmMxw8SD3WCFVm5kY8uReidZ1KPIKkgJ1hCkG/n/axciphqpnohg/b/forums-legacy/o/uploads/RYFH8BIGJWM1/image.png" alt="image.png">line 5 and line 6 starts with the same character 10990249
bring only with greater quantity of character
