Hi Team,
SELECT RECORD_COUNT FROM M_TABLES WHERE TABLE_TYPE = 'COLLECTION';
This always gives NULL.
we have many collection tables in a schema , where we store json objects in collection tables. we need to find the count of all json objects stored in a schema. is there any way.
At collection table level i get count by
SELECT count(*) FROM "my_Collecttion_table_name_1";--2 ROWS
SELECT count(*) FROM "my_Collecttion_table_name_2";--10 ROWS
SELECT count(*) FROM "my_Collecttion_table_name_3";--20 ROWS
I need to get 32 row count info at schema level. how can I get this ?
SELECT sum(RECORD_COUNT) FROM M_TABLES WHERE TABLE_TYPE = 'COLLECTION' and TABLE_NAME LIKE '%_name_%';
This always gives NULL.