Hi
I have used more than one version of your wonderful program
But there is a problem
It is when you open any table containing data in Arabic and choose the data field and enter the search for a word in Arabic for a specific field appears data normally
But about doing this research again, the program freezes completely
So please help me either change the settings or solve this problem
Thank you
can you provide a sample table with similar data?
and version of oracle database?
It might also help to see if the hang occurs waiting for the DB to respond with a result set or during rendering of the result in the object browser. Open the Statement Log before adding the filter, as in my test case:
The statement at Sequence 60 is the default Data tab query, while Sequence 62 is the filtered query.
Thanks for the quick answer
These are the data
CREATE TABLE UNPAID
( UPD_NO NUMBER(8,0) NOT NULL ENABLE,
UPD_DATE DATE NOT NULL ENABLE,
UPD_TYPE NUMBER(3,0),
UPD_LOCAT VARCHAR2(70 BYTE),
UPD_TIME DATE,
UPD_AMONT NUMBER(7,0),
UPD_NAME VARCHAR2(70 BYTE),
UPD_POSIT NUMBER(3,0),
UPD_CAR_NO VARCHAR2(8 BYTE) NOT NULL ENABLE,
UPD_CAR_TYPE NUMBER(3,0) NOT NULL ENABLE,
UPD_CAR_REGY NUMBER(3,0) NOT NULL ENABLE,
UPD_IN_DATE DATE NOT NULL ENABLE,
UPD_IN_USER NUMBER(5,0),
MUH NUMBER(2,0) NOT NULL ENABLE
)
--------------------------------------------------------
-- File created - الأربعاء-ديسمبر-04-2019
--------------------------------------------------------
REM INSERTING into UNPAID
SET DEFINE OFF;
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (77178,to_date('03/08/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',1,'295717',1,1,to_date('06/12/04','DD/MM/RR'),10,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (71811,to_date('20/07/04','DD/MM/RR'),11,'كهرباءالشورجة/الجمهوري/السنك',null,20000,'ابراهيم نجم',2,'331745',1,1,to_date('04/12/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (77173,to_date('03/08/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',1,'133457',1,1,to_date('06/12/04','DD/MM/RR'),10,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (71849,to_date('23/07/04','DD/MM/RR'),11,'كهرباءالشورجة/الجمهوري/السنك',null,20000,'ابراهيم نجم',2,'12488',1,1,to_date('04/12/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (193027,to_date('05/12/04','DD/MM/RR'),11,'الشورجة /الكهرباء',null,20000,'زياد جلال',4,'131507',1,1,to_date('12/01/05','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (193033,to_date('07/12/04','DD/MM/RR'),11,'الشورجة /الكهرباء',null,20000,'زياد جلال',4,'24910',1,1,to_date('12/01/05','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (46861,to_date('02/10/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'جاسم محمد',1,'218650',1,1,to_date('12/12/04','DD/MM/RR'),16,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (191339,to_date('08/07/04','DD/MM/RR'),1,'بابل/تقاطع الكهرباء',null,30000,'غير معروف',null,'62926',1,1,to_date('19/12/04','DD/MM/RR'),32,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (71830,to_date('21/07/04','DD/MM/RR'),11,'كهرباءالشورجة/الجمهوري/السنك',null,20000,'ابراهيم نجم',2,'43984',1,1,to_date('04/12/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (69089,to_date('12/07/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'ابراهيم نجم عبدالله',2,'54970',1,1,to_date('29/11/04','DD/MM/RR'),23,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (549788,to_date('23/11/05','DD/MM/RR'),11,'الشورجة/الكهرباء/جسر المشاة/الخلاني /الوثبة',null,20000,'زيدان خليف',6,'232351',1,1,to_date('18/12/05','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (552300,to_date('21/12/05','DD/MM/RR'),11,'الشورجة/جسر المشاة/الكهرباء/الرهون/الرصافي',null,20000,'زيدان خليف',6,'255643',1,1,to_date('09/01/06','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (549380,to_date('19/11/05','DD/MM/RR'),11,'الشورجة/الكهرباء',null,20000,'زيدان خليف',6,'331845',1,1,to_date('29/11/05','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (290040,to_date('04/03/05','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'مصطفى محمود',3,'189483',1,1,to_date('20/03/05','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (271109,to_date('08/02/05','DD/MM/RR'),11,'الشورجة-/الكهرباء',null,20000,'زياد جلال',4,'202336',1,1,to_date('28/02/05','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (716296,to_date('08/04/06','DD/MM/RR'),11,'الشورخه الكهرباء',null,20000,' حسام طالب',2,'318478',1,1,to_date('19/04/06','DD/MM/RR'),58,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (971756,to_date('23/04/06','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام',2,'170174',1,1,to_date('15/05/06','DD/MM/RR'),14,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (716256,to_date('30/03/06','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',2,'3291',1,1,to_date('03/09/06','DD/MM/RR'),93,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (682902,to_date('18/02/06','DD/MM/RR'),11,'شارع الخلفاء /كهرباء /الشورجة',null,20000,'حسام طالب',1,'165285',1,1,to_date('13/03/06','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (716269,to_date('01/04/06','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',2,'228868',1,1,to_date('18/07/06','DD/MM/RR'),62,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (494287,to_date('10/10/11','DD/MM/RR'),11,'الاسكان/مقابل دائر كهرباءالكرخ',null,20000,'باسم جاسم',5,'244968',1,1,to_date('27/10/11','DD/MM/RR'),197,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (134511,to_date('17/06/12','DD/MM/RR'),11,'مقابل كهرباء الكرخ',null,20000,'باسم جاسم',5,'230794',1,1,to_date('03/07/12','DD/MM/RR'),259,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (134532,to_date('21/06/12','DD/MM/RR'),11,'مقابل كهرباء الكرخ',null,20000,'باسم جاسم',5,'46366',1,1,to_date('03/07/12','DD/MM/RR'),259,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (134547,to_date('21/06/12','DD/MM/RR'),11,'مقابل كهرباء الكرخ',null,20000,'باسم جاسم',5,'116297',1,1,to_date('03/07/12','DD/MM/RR'),259,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499118,to_date('01/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'87757ي',1,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499145,to_date('04/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'82684ي',1,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499814,to_date('06/10/16','DD/MM/RR'),1,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'183208',1,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499820,to_date('06/10/16','DD/MM/RR'),1,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'64211ه',1,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499827,to_date('08/10/16','DD/MM/RR'),2,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'51263ف',1,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499834,to_date('08/10/16','DD/MM/RR'),2,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'71704ر',1,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (191149,to_date('27/11/04','DD/MM/RR'),11,'الشورجة /الكهرباء',null,20000,'زياد صلاح',4,'9552',2,1,to_date('13/12/04','DD/MM/RR'),15,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (75550,to_date('29/07/04','DD/MM/RR'),11,'كهرباء الشورجه',null,20000,'حسام طالب',1,'47275',2,1,to_date('06/12/04','DD/MM/RR'),5,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (71836,to_date('23/06/04','DD/MM/RR'),11,'كهرباءالشورجة/الجمهوري/السنك',null,20000,'ابراهيم نجم',2,'8851',2,1,to_date('04/12/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (193013,to_date('30/11/04','DD/MM/RR'),11,'الشورجة /الكهرباء',null,20000,'زياد جلال',4,'11094',2,1,to_date('12/01/05','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (18959,to_date('12/03/05','DD/MM/RR'),11,' الشورجة - الكهرباء',null,20000,'زياد جلال',4,'8487',2,1,to_date('14/04/05','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (669146,to_date('17/08/06','DD/MM/RR'),1,'تقاطع الكهرباء بابل',null,30000,'1',1,'46279',2,1,to_date('03/09/06','DD/MM/RR'),12,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (280251,to_date('12/02/05','DD/MM/RR'),11,'الشورجه الكهرباء',null,20000,'زيادجلال',4,'69767',2,1,to_date('15/03/05','DD/MM/RR'),56,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (494285,to_date('10/10/11','DD/MM/RR'),11,'الاسكان/مقابل دائر كهرباءالكرخ',null,20000,'باسم جاسم',5,'59439',2,1,to_date('27/10/11','DD/MM/RR'),197,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499144,to_date('04/10/16','DD/MM/RR'),11,'سيطرو الكهرباء',null,20000,'احمد جلال',2,'50306ج',2,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499103,to_date('01/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'165512',2,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499104,to_date('01/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'32375ط',2,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499108,to_date('01/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'1118',2,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499113,to_date('01/10/16','DD/MM/RR'),1,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'25140ه',2,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499114,to_date('01/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'5143د',2,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499116,to_date('01/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'8034ا',2,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499119,to_date('01/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'135186',2,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499133,to_date('03/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'7225د',2,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499825,to_date('08/10/16','DD/MM/RR'),12,'سيطرة الكهرباء',null,20000,'احمد جلال',2,'42369ج',2,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499829,to_date('08/10/16','DD/MM/RR'),2,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'16112ط',2,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499839,to_date('09/10/16','DD/MM/RR'),2,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'11694ط',2,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (683835,to_date('14/03/06','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',2,'38488',3,1,to_date('30/04/06','DD/MM/RR'),57,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (683862,to_date('09/03/06','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',2,'52523',3,1,to_date('29/03/06','DD/MM/RR'),89,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (77169,to_date('02/08/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',1,'79547',3,1,to_date('06/12/04','DD/MM/RR'),10,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (609334,to_date('24/01/06','DD/MM/RR'),11,'كهرباء الشورجه',null,20000,'حسام طالب',2,'21327',3,1,to_date('14/02/06','DD/MM/RR'),58,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499836,to_date('08/10/16','DD/MM/RR'),2,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'54121و',3,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499844,to_date('09/10/16','DD/MM/RR'),1,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'58078ط',3,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499848,to_date('09/10/16','DD/MM/RR'),1,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'38324',3,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499805,to_date('06/10/16','DD/MM/RR'),17,'سيطرة الكهرباء',null,15000,'احمد جلال',2,'41419',3,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499809,to_date('06/10/16','DD/MM/RR'),1,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'59958ط',3,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499817,to_date('06/10/16','DD/MM/RR'),1,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'5464ر',3,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499105,to_date('01/10/16','DD/MM/RR'),17,'سيطرو الكهرباء',null,15000,'احمد جلال',2,'64018',3,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499122,to_date('02/10/16','DD/MM/RR'),1,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'18441',3,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499140,to_date('03/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'50391و',3,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499142,to_date('04/10/16','DD/MM/RR'),11,'سيطرو الكهرباء',null,20000,'احمد جلال',2,'5847ج',3,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499143,to_date('04/10/16','DD/MM/RR'),1,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'610',3,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499150,to_date('04/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'61860',3,1,to_date('23/10/16','DD/MM/RR'),362,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70807,to_date('13/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70848,to_date('17/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73355,to_date('23/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73372,to_date('23/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73400,to_date('25/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70837,to_date('16/07/04','DD/MM/RR'),11,'الكهرباء/الشورجة',null,20000,'ابراهيم نجم',2,'162',8,9,to_date('29/11/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73365,to_date('23/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73387,to_date('24/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73388,to_date('24/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73385,to_date('24/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73386,to_date('24/07/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',1,'105748',7,1,to_date('21/11/04','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (71838,to_date('23/07/04','DD/MM/RR'),0,'كهرباءالشورجة/الجمهوري/السنك',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('04/12/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73371,to_date('23/07/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',1,'7359',8,7,to_date('21/11/04','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73367,to_date('23/07/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',1,'232355',7,1,to_date('21/11/04','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (193041,to_date('09/12/04','DD/MM/RR'),0,'الشورجة /الكهرباء',null,null,'زياد جلال',4,'9999999',999,999,to_date('12/01/05','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70834,to_date('15/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70816,to_date('14/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70819,to_date('14/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70821,to_date('14/07/04','DD/MM/RR'),11,'الكهرباء/الشورجة',null,20000,'ابراهيم نجم',2,'72589',7,1,to_date('29/11/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70823,to_date('14/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70824,to_date('14/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (71843,to_date('23/07/04','DD/MM/RR'),0,'كهرباءالشورجة/الجمهوري/السنك',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('04/12/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70829,to_date('14/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70830,to_date('14/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (69083,to_date('10/07/04','DD/MM/RR'),11,'كهرباء الشورجة',to_date('01/11/04','DD/MM/RR'),20000,'ابراهيم نجم عبدالله',2,'1345',7,2,to_date('17/01/05','DD/MM/RR'),31,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (193001,to_date('28/11/04','DD/MM/RR'),0,'الشورجة /الكهرباء',null,null,'زياد جلال',4,'9999999',999,999,to_date('12/01/05','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73391,to_date('25/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (71840,to_date('23/07/04','DD/MM/RR'),0,'كهرباءالشورجة/الجمهوري/السنك',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('04/12/04','DD/MM/RR'),13,1);
Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (549771,to_date('21/11/05','DD/MM/RR'),0,'الشورجة/الكهرباء',null,null,'زيدان خليف',6,'9999999',999,999,to_date('29/11/05','DD/MM/RR'),20,1);
I'll do it and try
May the problem be solved
Thank you
Now freeze as pictured below
I took your table definition and the first two lines of data as a test case, running the DDL and the two INSERTS, then committing the rows.
Next, in the Object Viewer, I filtered on each of the two UPD_LOCAT arabic values using the "=" operator rather than "LIKE", closing the object viewer after each attempt. All seemed to work fine.
But then I decided to use the Filter input box's LOV to select one of the predicates I had previously entered. Interestingly, after running the first one, I tried to edit the arabic string in the Filter input box. The focus was after the right-most single-quote of the predicate. Eureka! A (destructive) backspace from the end of the predicate, rather than moving (and destroying) the character one space to the left, jumps all the way to the left single-quote without destroying any of the arabic characters. And hangs SQL Developer.
Here is a jstack:
2019-12-04 14:52:10 Full thread dump Java HotSpot(TM) 64-Bit Server VM (25.221-b11 mixed mode): "Background Parser#2" #330 prio=6 os_prio=0 tid=0x000000002b5a0000 nid=0x4ec waiting on condition [0x000000001fc6f000] java.lang.Thread.State: TIMED_WAITING (sleeping) at java.lang.Thread.sleep(Native Method) at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:160) at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115) at java.lang.Thread.run(Thread.java:748) "RaptorTaskThread10" #297 prio=5 os_prio=0 tid=0x0000000029f4d000 nid=0x56d8 waiting on condition [0x000000001c83e000] java.lang.Thread.State: WAITING (parking) at sun.misc.Unsafe.park(Native Method) - parking to wait for <0x0000000082230b40> (a java.util.concurrent.SynchronousQueue$TransferStack) at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175) at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:458) at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362) at java.util.concurrent.SynchronousQueue.take(SynchronousQueue.java:924) at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) "Image Animator 3" #116 daemon prio=3 os_prio=-1 tid=0x0000000025518800 nid=0x1fe0 waiting on condition [0x000000002871e000] java.lang.Thread.State: TIMED_WAITING (sleeping) at java.lang.Thread.sleep(Native Method) at sun.awt.image.GifFrame.dispose(GifImageDecoder.java:670) at sun.awt.image.GifImageDecoder.readImage(GifImageDecoder.java:458) at sun.awt.image.GifImageDecoder.produceImage(GifImageDecoder.java:212) at sun.awt.image.InputStreamImageSource.doFetch(InputStreamImageSource.java:269) at sun.awt.image.ImageFetcher.fetchloop(ImageFetcher.java:205) at sun.awt.image.ImageFetcher.run(ImageFetcher.java:169) "Background Parser#1" #85 prio=5 os_prio=0 tid=0x0000000025515800 nid=0x5fbc waiting on condition [0x000000003249f000] java.lang.Thread.State: TIMED_WAITING (sleeping) at java.lang.Thread.sleep(Native Method) at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:160) at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115) at java.lang.Thread.run(Thread.java:748) "status-0" #84 prio=2 os_prio=-2 tid=0x0000000025514000 nid=0x3d00 waiting on condition [0x000000003269f000] java.lang.Thread.State: WAITING (parking) at sun.misc.Unsafe.park(Native Method) - parking to wait for <0x000000008558b340> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject) at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175) at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039) at java.util.concurrent.DelayQueue.take(DelayQueue.java:211) at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:338) at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:300) at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) "WeakDataReference polling" #82 prio=1 os_prio=-2 tid=0x000000002550f800 nid=0x5934 in Object.wait() [0x000000002ed0f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144) - locked <0x0000000085574538> (a java.lang.ref.ReferenceQueue$Lock) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:165) at oracle.ide.util.WeakDataReference$Cleaner.run(WeakDataReference.java:88) at java.lang.Thread.run(Thread.java:748) "Background Parser#0" #77 prio=6 os_prio=0 tid=0x0000000025511800 nid=0x539c waiting on condition [0x000000003365f000] java.lang.Thread.State: TIMED_WAITING (sleeping) at java.lang.Thread.sleep(Native Method) at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:160) at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115) at java.lang.Thread.run(Thread.java:748) "TextBufferScavenger" #75 prio=6 os_prio=0 tid=0x0000000025513000 nid=0x5084 in Object.wait() [0x0000000032c3e000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144) - locked <0x0000000085ec9748> (a java.lang.ref.ReferenceQueue$Lock) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:165) at oracle.ide.model.FacadeBufferReference$PollingThread.run(FacadeBufferReference.java:145) "oracle.jdbc.driver.BlockSource.ThreadedCachingBlockSource.BlockReleaser" #69 daemon prio=4 os_prio=-1 tid=0x0000000029f49000 nid=0x3f94 in Object.wait() [0x0000000032f3f000] java.lang.Thread.State: TIMED_WAITING (on object monitor) at java.lang.Object.wait(Native Method) at oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser.run(BlockSource.java:331) - locked <0x00000000847a4688> (a oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser) "Timer-3" #68 daemon prio=5 os_prio=0 tid=0x0000000029f48800 nid=0x3eec in Object.wait() [0x0000000032e3f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:502) at java.util.TimerThread.mainLoop(Timer.java:526) - locked <0x00000000847a4b50> (a java.util.TaskQueue) at java.util.TimerThread.run(Timer.java:505) "pool-5-thread-1" #64 prio=5 os_prio=0 tid=0x000000002429e800 nid=0x423c waiting on condition [0x000000002ea0e000] java.lang.Thread.State: TIMED_WAITING (parking) at sun.misc.Unsafe.park(Native Method) - parking to wait for <0x0000000084b76cc8> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject) at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215) at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2078) at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1093) at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:809) at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) "IconOverlayTracker Timer: null-jdbcNodeInfoType" #51 prio=5 os_prio=0 tid=0x0000000024297800 nid=0x5904 in Object.wait() [0x000000003219e000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:502) at java.util.TimerThread.mainLoop(Timer.java:526) - locked <0x00000000847a5188> (a java.util.TaskQueue) at java.util.TimerThread.run(Timer.java:505) "Swing-Shell" #45 daemon prio=6 os_prio=0 tid=0x0000000024297000 nid=0x2a14 waiting on condition [0x0000000030a2e000] java.lang.Thread.State: WAITING (parking) at sun.misc.Unsafe.park(Native Method) - parking to wait for <0x000000008388f910> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject) at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175) at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039) at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442) at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at sun.awt.shell.Win32ShellFolderManager2$ComInvoker$3.run(Win32ShellFolderManager2.java:556) at java.lang.Thread.run(Thread.java:748) "WaitCursor-Timer" #43 prio=6 os_prio=0 tid=0x0000000024295800 nid=0x2e90 in Object.wait() [0x000000003092f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:502) at java.util.TimerThread.mainLoop(Timer.java:526) - locked <0x000000008388fe18> (a java.util.TaskQueue) at java.util.TimerThread.run(Timer.java:505) "InterruptTimer" #42 daemon prio=5 os_prio=0 tid=0x0000000024299000 nid=0x5338 in Object.wait() [0x00000000302ef000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:502) at java.util.TimerThread.mainLoop(Timer.java:526) - locked <0x00000000835086b0> (a java.util.TaskQueue) at java.util.TimerThread.run(Timer.java:505) "Thread-8" #38 daemon prio=5 os_prio=0 tid=0x0000000029f4c000 nid=0x3310 in Object.wait() [0x000000002f8ef000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:502) at java.util.prefs.AbstractPreferences$EventDispatchThread.run(AbstractPreferences.java:1482) - locked <0x0000000080578dd0> (a java.util.LinkedList) "ChangeSetService" #36 daemon prio=1 os_prio=-2 tid=0x0000000029f46800 nid=0x3648 in Object.wait() [0x000000002e90f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:502) at oracle.jdevimpl.vcs.changeset.ChangeSetService.awaitEvents(ChangeSetService.java:131) - locked <0x00000000831a2e98> (a oracle.jdevimpl.vcs.changeset.ChangeSetService) at oracle.jdevimpl.vcs.changeset.ChangeSetService.eventLoop(ChangeSetService.java:152) at oracle.jdevimpl.vcs.changeset.ChangeSetService.access$000(ChangeSetService.java:60) at oracle.jdevimpl.vcs.changeset.ChangeSetService$1.run(ChangeSetService.java:99) at java.lang.Thread.run(Thread.java:748) "Scheduler" #35 daemon prio=5 os_prio=0 tid=0x0000000029f4b800 nid=0x4a6c in Object.wait() [0x000000002ccfe000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:502) at oracle.dbtools.raptor.backgroundTask.TaskLinkedList.takeNextTask(TaskLinkedList.java:47) - locked <0x0000000082230368> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList) at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThread.run(RaptorTaskManager.java:548) "Log Poller" #34 prio=1 os_prio=-2 tid=0x0000000029f4d800 nid=0x36e4 waiting on condition [0x0000000028bde000] java.lang.Thread.State: WAITING (parking) at sun.misc.Unsafe.park(Native Method) - parking to wait for <0x0000000081d567a8> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject) at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175) at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039) at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442) at oracle.ide.log.QueuedLoggingHandler.take(QueuedLoggingHandler.java:60) at oracle.ideimpl.log.TabbedLogManager$4.run(TabbedLogManager.java:333) at java.lang.Thread.run(Thread.java:748) "TimedCache-Timer" #30 daemon prio=5 os_prio=0 tid=0x0000000024339000 nid=0x3b14 in Object.wait() [0x0000000028adf000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:502) at java.util.TimerThread.mainLoop(Timer.java:526) - locked <0x0000000081050e30> (a java.util.TaskQueue) at java.util.TimerThread.run(Timer.java:505) "Framework Event Dispatcher" #26 daemon prio=6 os_prio=0 tid=0x0000000024335000 nid=0x43dc in Object.wait() [0x00000000261ce000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:502) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.getNextEvent(EventManager.java:400) - locked <0x00000000804839f8> (a org.eclipse.osgi.framework.eventmgr.EventManager$EventThread) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:336) "State Data Manager" #24 daemon prio=5 os_prio=0 tid=0x0000000024336000 nid=0x211c waiting on condition [0x0000000024dff000] java.lang.Thread.State: TIMED_WAITING (sleeping) at java.lang.Thread.sleep(Native Method) at org.eclipse.osgi.internal.baseadaptor.StateManager.run(StateManager.java:297) at java.lang.Thread.run(Thread.java:748) "Framework Active Thread" #23 prio=5 os_prio=0 tid=0x0000000024334800 nid=0x6120 in Object.wait() [0x0000000024cff000] java.lang.Thread.State: TIMED_WAITING (on object monitor) at java.lang.Object.wait(Native Method) at org.eclipse.osgi.framework.internal.core.Framework.run(Framework.java:1870) - locked <0x00000000805d5228> (a org.eclipse.osgi.framework.internal.core.Framework) at java.lang.Thread.run(Thread.java:748) "Active Reference Queue Daemon" #19 daemon prio=1 os_prio=-2 tid=0x000000001baf9000 nid=0x29dc in Object.wait() [0x000000001db1f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144) - locked <0x00000000805db0e8> (a java.lang.ref.ReferenceQueue$Lock) at org.openide.util.lookup.implspi.ActiveQueue$Impl.removeSuper(ActiveQueue.java:93) at org.openide.util.lookup.implspi.ActiveQueue$Daemon.run(ActiveQueue.java:131) "TimerQueue" #17 daemon prio=5 os_prio=0 tid=0x000000001b8f5800 nid=0x2330 waiting on condition [0x000000001ce1e000] java.lang.Thread.State: TIMED_WAITING (parking) at sun.misc.Unsafe.park(Native Method) - parking to wait for <0x000000008046ce28> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject) at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215) at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2078) at java.util.concurrent.DelayQueue.take(DelayQueue.java:223) at javax.swing.TimerQueue.run(TimerQueue.java:174) at java.lang.Thread.run(Thread.java:748) "AWT-EventQueue-0" #16 prio=6 os_prio=0 tid=0x000000001b81c000 nid=0x40a0 runnable [0x000000001c46c000] java.lang.Thread.State: RUNNABLE at javax.swing.text.BoxView.updateLayoutArray(BoxView.java:211) at javax.swing.text.BoxView.replace(BoxView.java:190) at javax.swing.text.View.append(View.java:417) at javax.swing.text.FlowView$FlowStrategy.layout(FlowView.java:473) at javax.swing.text.TextLayoutStrategy.layout(TextLayoutStrategy.java:110) at javax.swing.text.FlowView.layout(FlowView.java:201) at javax.swing.text.BoxView.setSize(BoxView.java:397) at javax.swing.plaf.basic.BasicTextUI$RootView.setSize(BasicTextUI.java:1722) at javax.swing.plaf.basic.BasicTextUI.modelToView(BasicTextUI.java:1046) at javax.swing.plaf.basic.BasicTextUI.modelToView(BasicTextUI.java:1022) at oracle.javatools.controls.completionfield.CompletionPopupHandler.updateInsight(CompletionPopupHandler.java:701) at oracle.javatools.controls.completionfield.CompletionPopupHandler.access$1400(CompletionPopupHandler.java:80) at oracle.javatools.controls.completionfield.CompletionPopupHandler$CaretHandler.caretUpdate(CompletionPopupHandler.java:887) at javax.swing.text.JTextComponent.fireCaretUpdate(JTextComponent.java:397) at javax.swing.text.JTextComponent$MutableCaretEvent.fire(JTextComponent.java:4394) at javax.swing.text.JTextComponent$MutableCaretEvent.stateChanged(JTextComponent.java:4416) at javax.swing.text.DefaultCaret.fireStateChanged(DefaultCaret.java:802) at javax.swing.text.DefaultCaret.changeCaretPosition(DefaultCaret.java:1274) at javax.swing.text.DefaultCaret.handleSetDot(DefaultCaret.java:1173) at javax.swing.text.DefaultCaret.setDot(DefaultCaret.java:1154) at javax.swing.text.DefaultCaret$Handler.insertUpdate(DefaultCaret.java:1723) at javax.swing.text.AbstractDocument.fireInsertUpdate(AbstractDocument.java:201) at javax.swing.text.AbstractDocument.handleInsertString(AbstractDocument.java:748) at javax.swing.text.AbstractDocument.insertString(AbstractDocument.java:707) at javax.swing.text.PlainDocument.insertString(PlainDocument.java:130) at oracle.dbtools.raptor.controls.grid.GridFilterInsightProvider.completeInsight(GridFilterInsightProvider.java:73) at oracle.javatools.controls.completionfield.CompletionPopupHandler.completeInsight(CompletionPopupHandler.java:815) at oracle.javatools.controls.completionfield.CompletionPopupHandler.access$1200(CompletionPopupHandler.java:80) at oracle.javatools.controls.completionfield.CompletionPopupHandler$CompleteInsightAction.actionPerformed(CompletionPopupHandler.java:833) at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1668) at javax.swing.JComponent.processKeyBinding(JComponent.java:2882) at javax.swing.JComponent.processKeyBindings(JComponent.java:2929) at javax.swing.JComponent.processKeyEvent(JComponent.java:2845) at java.awt.Component.processEvent(Component.java:6316) at java.awt.Container.processEvent(Container.java:2239) at java.awt.Component.dispatchEventImpl(Component.java:4889) at java.awt.Container.dispatchEventImpl(Container.java:2297) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1954) at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:835) at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1103) at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:974) at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:800) at java.awt.Component.dispatchEventImpl(Component.java:4760) at java.awt.Container.dispatchEventImpl(Container.java:2297) at java.awt.Window.dispatchEventImpl(Window.java:2746) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84) at java.awt.EventQueue$4.run(EventQueue.java:733) at java.awt.EventQueue$4.run(EventQueue.java:731) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at java.awt.EventQueue.dispatchEvent(EventQueue.java:730) at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169) at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) "AWT-Windows" #14 daemon prio=6 os_prio=0 tid=0x000000001b82d000 nid=0x3f64 runnable [0x000000001c36f000] java.lang.Thread.State: RUNNABLE at sun.awt.windows.WToolkit.eventLoop(Native Method) at sun.awt.windows.WToolkit.run(WToolkit.java:315) at java.lang.Thread.run(Thread.java:748) "AWT-Shutdown" #13 prio=5 os_prio=0 tid=0x000000001b82c000 nid=0x5a84 in Object.wait() [0x000000001c26f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:502) at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:295) - locked <0x0000000080482e50> (a java.lang.Object) at java.lang.Thread.run(Thread.java:748) "Java2D Disposer" #12 daemon prio=10 os_prio=2 tid=0x000000001b82b800 nid=0x63a0 in Object.wait() [0x000000001c16f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144) - locked <0x0000000080580908> (a java.lang.ref.ReferenceQueue$Lock) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:165) at sun.java2d.Disposer.run(Disposer.java:148) at java.lang.Thread.run(Thread.java:748) "Service Thread" #10 daemon prio=9 os_prio=0 tid=0x000000001a8ff800 nid=0x5d20 runnable [0x0000000000000000] java.lang.Thread.State: RUNNABLE "C1 CompilerThread3" #9 daemon prio=9 os_prio=2 tid=0x000000001a86f000 nid=0x3194 waiting on condition [0x0000000000000000] java.lang.Thread.State: RUNNABLE "C2 CompilerThread2" #8 daemon prio=9 os_prio=2 tid=0x000000001a867000 nid=0x31fc waiting on condition [0x0000000000000000] java.lang.Thread.State: RUNNABLE "C2 CompilerThread1" #7 daemon prio=9 os_prio=2 tid=0x000000001a865000 nid=0x13e0 waiting on condition [0x0000000000000000] java.lang.Thread.State: RUNNABLE "C2 CompilerThread0" #6 daemon prio=9 os_prio=2 tid=0x000000001a863000 nid=0x518 waiting on condition [0x0000000000000000] java.lang.Thread.State: RUNNABLE "Attach Listener" #5 daemon prio=5 os_prio=2 tid=0x000000001a861800 nid=0x4948 waiting on condition [0x0000000000000000] java.lang.Thread.State: RUNNABLE "Signal Dispatcher" #4 daemon prio=9 os_prio=2 tid=0x0000000018a5e800 nid=0x2044 runnable [0x0000000000000000] java.lang.Thread.State: RUNNABLE "Finalizer" #3 daemon prio=8 os_prio=1 tid=0x000000001a851000 nid=0x5410 in Object.wait() [0x000000001ae2e000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144) - locked <0x00000000805f90a0> (a java.lang.ref.ReferenceQueue$Lock) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:165) at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:216) "Reference Handler" #2 daemon prio=10 os_prio=2 tid=0x0000000018a4d000 nid=0x6348 in Object.wait() [0x000000001ad2f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:502) at java.lang.ref.Reference.tryHandlePending(Reference.java:191) - locked <0x00000000804dc2e0> (a java.lang.ref.Reference$Lock) at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:153) "main" #1 prio=5 os_prio=0 tid=0x00000000038e8000 nid=0x61fc waiting on condition [0x0000000000000000] java.lang.Thread.State: RUNNABLE "VM Thread" os_prio=2 tid=0x0000000018a45800 nid=0x1fdc runnable "GC task thread#0 (ParallelGC)" os_prio=0 tid=0x00000000038fc800 nid=0x1b30 runnable "GC task thread#1 (ParallelGC)" os_prio=0 tid=0x00000000038fe000 nid=0x5ae8 runnable "GC task thread#2 (ParallelGC)" os_prio=0 tid=0x00000000038ff800 nid=0x15c4 runnable "GC task thread#3 (ParallelGC)" os_prio=0 tid=0x0000000003901800 nid=0x540 runnable "GC task thread#4 (ParallelGC)" os_prio=0 tid=0x0000000003904000 nid=0x42dc runnable "GC task thread#5 (ParallelGC)" os_prio=0 tid=0x0000000003905000 nid=0x2f74 runnable "GC task thread#6 (ParallelGC)" os_prio=0 tid=0x0000000003908000 nid=0x4768 runnable "GC task thread#7 (ParallelGC)" os_prio=0 tid=0x0000000003909800 nid=0x9d8 runnable "VM Periodic Task Thread" os_prio=2 tid=0x000000001a91a800 nid=0x2864 waiting on condition JNI global references: 3491
Just to add some context, this was using SQL Developer 19.2.1 against an 11g XE DB with an installed NLS_CHARACTERSET of AL32UTF8.
So, basically, it works fine if I copy/paste an Arabic text string into the Filter input field, but any attempt to edit the Arabic within the input field results in a hang.
thanks for all the info, I have logged a bug
Thanks for discovering the main problem
And make that effort
So will this problem be solved in the next version ??
I repeat my thanks and appreciation to you
It's too late for both 19.3 and 19.4, hopefully for 20.1
