| Selecting/Inserting Missing values [message #644874] |
Thu, 19 November 2015 04:31  |
 |
tigsav
Messages: 49
Registered: April 2012
|
Member |
|
|
Hi Experts,
I need a help in inserting missing data .
PFB the DDL for test case;
create table test1
(id number,
value number,
dt_value date);
insert into test1 values (1,2,SYSDATE-5);
insert into test1 values (1,4,SYSDATE-4);
insert into test1 values (1,4,SYSDATE);
commit;
I need the output from same table along with missing dates
i.e I am having data for 15th,16th, and 19th.
for 17,18 the data(value) should be present as zero.
|
|
|
|
|
|
| Re: Selecting/Inserting Missing values [message #645014 is a reply to message #644875] |
Mon, 23 November 2015 10:57  |
|
tigsav
Messages: 49
Registered: April 2012
|
Member |
|
|
Thanks a lot John.
No,It was not a HW Assignment. Its a particular scenario which we were facing.
The scenario on a similar lines would be capturing the time a person has run in a day. However we are not getting data from cloud when the person does-not run for the day thereby causing missing data.
Regards,
Tigsav
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
