select
a.subobject_name
from dba_objects a join (
select
dbms_rowid.rowid_object(rowid) object_id
from NEWLOG4
where TO_CHAR(autudt,'YYYY-MM-DD') = '2021-06-22'
) b
on a.object_id =b.object_id and object_name = UPPER('NEWLOG4') group by a.subobject_name
09-14
266