OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » View creation (12c and 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

View creation [message #684445]

Tue, 08 June 2021 06:29

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.

Report message to a moderator

Re: View creation [message #684446 is a reply to message #684445]

Tue, 08 June 2021 07:39

John Watson
Messages: 8624
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.

Report message to a moderator

Previous Topic:	How to spead up query that calls the save view multiple times
Next Topic:	Compare rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 24 02:15:47 CDT 2021