Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find out missing dates

user650888Sep 2 2025

create table gtest1(Tdate date, asset_name varchar2(100),asset_value number);

insert into gtest1 values('01-AUG-2025','ABC',100);
insert into gtest1 values('01-AUG-2025','ABC',300);
insert into gtest1 values('01-AUG-2025','ABC',400);
insert into gtest1 values('01-AUG-2025','ABC',600);

insert into gtest1 values('02-AUG-2025','ABC',100);
insert into gtest1 values('02-AUG-2025','ABC',300);
insert into gtest1 values('02-AUG-2025','ABC',400);
insert into gtest1 values('02-AUG-2025','ABC',600);

insert into gtest1 values('04-AUG-2025','ABC',100);
insert into gtest1 values('04-AUG-2025','ABC',300);
insert into gtest1 values('04-AUG-2025','ABC',400);
insert into gtest1 values('04-AUG-2025','ABC',600);

insert into gtest1 values('05-AUG-2025','ABC',100);
insert into gtest1 values('05-AUG-2025','ABC',300);
insert into gtest1 values('05-AUG-2025','ABC',400);
insert into gtest1 values('05-AUG-2025','ABC',600);

COMMIT;

SELECT COUNT(*),ASSET_NAME,TDATE
FROM GTEST1
GROUP BY ASSET_NAME,TDATE
ORDER BY TDATE;

Data is missing for august 3rd, so given a range of august 1 - till august 31 - how can I print the days where there is no data at all?

Comments
Post Details
Added on Sep 2 2025
10 comments
278 views