Home » SQL & PL/SQL » SQL & PL/SQL » View creation (12c and 11g)
View creation [message #684445] Tue, 08 June 2021 06:29 Go to next message
BunnyWorld123
Messages: 1
Registered: June 2021
Junior Member
Hi All,
I need help in creating a view on a table which currently has status of feeds processing with current status . My requirement is to show empty rows for the feeds for future dates along with processed data without actually putting data in table for future dates. So that users can see when the next feed is expected.
Re: View creation [message #684446 is a reply to message #684445] Tue, 08 June 2021 07:39 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

You could generate a list of the dates in which you are interested as an inline view. For example, the next two weeks:
select trunc(sysdate) + rownum future_date from dual connect by level < 15;
and outer join that to your table.
Previous Topic: How to spead up query that calls the save view multiple times
Next Topic: Compare rows
Goto Forum:
  


Current Time: Thu Mar 28 13:27:30 CDT 2024