Hello Experts,
I have on table with below cols.
CREATE TABLE "TABLELIST"
( "TABLENAME" VARCHAR2(50 BYTE),
"CHECKCODE" NUMBER
);
and value as
Insert into TABLELIST (TABLENAME,CHECKCODE) values ('table',1);
Insert into TABLELIST (TABLENAME,CHECKCODE) values ('table2',1);
Insert into TABLELIST (TABLENAME,CHECKCODE) values ('table3',2);
Insert into TABLELIST (TABLENAME,CHECKCODE) values ('table4',2);
I need to write code that compare table count for tables with same check code. Let say i need to check for the count for table and table 2,if they are same or not.
I tried creating cursor for "tablelist" but I am not able store the count in any variable.
Please suggest some way for this.