Hi
I need to create a report that displays from the dt_lanc field controlling by fields (seq, attend ) repeat the data until you have a new seq for a more recent date.
--create table
CREATE TABLE dados (
seq number(10) not null,
atend number(10) not null,
pac varchar(255),
dt_lanc date,
dados varchar(255));
--insert
Insert into dados (seq,atend,pac,dt_lanc,dados) values (1,10,'dados',sysdate,'Manha');
Insert into dados (seq,atend,pac,dt_lanc,dados) values (2,10,'dados',sysdate+4,'Tarde');
--data
select seq,
atend,
pac,
to_char(dt_lanc,'dd/mm/yyyy') as dt,
dados
from dados;
<img src="https://objectstorage.us-phoenix-1.oraclecloud.com/p/BqK85Rn1zA5MP0vYiqbAdPgs7Z6OmMxw8SD3WCFVm5kY8uReidZ1KPIKkgJ1hCkG/n/axciphqpnohg/b/forums-legacy/o/uploads/URQ06OIC0GJG/image.png" alt="image.png">
I need you to repeat the data from the first row per day until the next seq that has a new date
Example:
<img src="https://objectstorage.us-phoenix-1.oraclecloud.com/p/BqK85Rn1zA5MP0vYiqbAdPgs7Z6OmMxw8SD3WCFVm5kY8uReidZ1KPIKkgJ1hCkG/n/axciphqpnohg/b/forums-legacy/o/uploads/VR1YG9XUPRFQ/image.png" alt="image.png">